These examples are valid for all chart types – in structure and time depictions. Chart title. Percentage and absolute deviation between data series with data series labels. Percentage and absolute data labels can be formatted independently. By using Scenarios, the chart elements and axis carry information: deviation of forecast (hatched) to budget data is shown. Therefore the deviation axis is hollow. A value axis with help lines can be displayed optionally for all charts. Charts can be superimposed, thus enabling you to depict combination charts - in this case a line chart with data series labeling and data types for previous periods (grey rhombus), actual (black square), forecast (hatched rhombus) and planned data (hollow). Column chart with two data series (-labels) and use of Scenarios. Sales are shown with lighter and narrower columns, which can be controlled centrally by the use of Scenarios. Data labels are free to define. For example, use the apostrophe for the representation of millions. Emphasize the difference between two elements with the function Highlight. Scaling helper show different scales of charts. Multi-line axes labels are automatically copied from the source data. So-called Separators help to structure the category axis.
Waterfall ChartsA waterfall chart – often also called a flying bricks chart or, in finance, a bridge 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 element has to be defined: the Waterfall Calculation Path. This elementdetermines, whether the value to be shown is an in- or an outflow value. For further information to the Waterfall Calculation Path see appendix. It is, of course, possible to use the waterfall horizontally or vertically, just like all other charts. Additional deviation axes are also possible. Furthermore, Scenarios can be used for formatting. Please note that Scenarios will overwrite the colors of in- and outflows as well as the colors of sums and spans which have been defined on the tab Chart Specific. Above you can see a visualization of the operators for the calculation path and their effects on the elements of the waterfall chart. The following table gives some more explanations:
Function | Sign | Display |
---|
(Sub-)Total | = | Value is shown beginning at the axis. | Inflow | + | Increase of previous value and data label on the element. | Outflow | | Decrease of previous value and data label on the element. | Inflow Span | s+ | Positive overall change based on a totals item. | Outflow Span | s- | Negative overall change based on a totals item. | Neutral | 0 | Neutral position with own color scheme | Standard | „" | Difference to previous value according to data value sign (+/-). |
Further information on the calculation path can be found here: Waterfall Calculation Path. |