...
Excerpt | ||||
---|---|---|---|---|
Waterfall Calculation PathA waterfall chart – often also called a flying bricks chart – shows how an initial value is increased (inflow) or decreased (outflow) by a series of values, which lead to a final value – if necessary with subtotals and spans.
For a flexible use of the waterfall in graphomate charts an additional Data Series has to be defined: the Waterfall Calculation Path. This Data Series determines, whether the value to be shown is an in- or an outflow value, a (sub-)total or a span. In general, the sign of the data series value determines the effect on the (sub-) totals of the waterfall. Negative values are interpreted as outflow values, positive values are interpreted as inflow values and colored according to the color scheme on the Chart Specific tab. By default, the last element of a waterfall is interpreted as the sum total. A waterfall without entries in the Waterfall Calculation Path would therefore look like this. By defining the Waterfall Calculation Path the appearance and the sign of each waterfall element can be controlled independently - even via scripting language. The following options can be used: +=inflow Positive signs are suppressed, the -color is applied to the elements. -=outflow Negative signs are suppressed, the -color is applied to the elements. All signs are shown, the (0)-color is applied to the elements.0 =neutral position ==(Sub-)total The element starts at the value axis and the (=)-color is applied to those elements. s-=outflow span s+=inflow span
|