Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
Excerpt | ||
---|---|---|
Chart Typesgraphomate charts offer a whole wide range of new chart types which can be extensively customized according to your reporting requirements. We distinguish between the following chart types: We recommend these chart types for visualization of developments over time. For the comparison of structures or hierarchies we recommend the use of charts with a vertical category axis: All charts can always be used in vertical or horizontal orientation. The Comparison Group enables you to use the same scales. Each chart must be assigned to the same Comparison Group. It is possible to use up to 12 data series – either consecutively or – in a stacked chart - on top of each other. The name of a data series can be displayed at the data series itself or alternatively on the axis of the base chart. Deviation AxesWith a simple mouse click, graphomate charts enables you to set additional axes above all chart types, which display the percentage or absolutes deviations between two data series. Of course you can name the deviation series and display the names in the chart. Image AddedImage Added Scenarios (previously Data Types)Furthermore, each element of a chart can be formatted independently. This is achieved by using the Data TypesScenarios. These Data TypesScenarios enable you to use a customized visual language for your company. Data TypesScenarios are defined in the Data Types EditorScenarios Definition and then they are attributed to each element of a Data Series on the tab Data. The color, filling, shape and width of the chart elements can be defined by using Data TypesScenarios. Please note that the use of Data TypesScenarios affects the deviation axes: The Data TypeScenario of the Measures can Subtrahend can be seen in the elements, the Data Type Scenario of the Base valuesMinuend is used in the axis – as long as the axis has a thickness of at least 3 px. Visual Elements of the graphomate chartsThese examples are valid for all chart types – in structure and time depictions. Image Removed
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 for Excel 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. 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, Data Types can be used for formatting. Please note that Data Types will overwrite the colors of in- and outflows as well as the colors of sums and spans which have been defined on the tab Appearance. Image RemovedAbove 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 (+/-).