Chart features

Growth Arrow

A growth arrow displays the growth between two data points. In order to set up a growth arrow, click on Lines in the Action Bar and select Growth Arrow. A further section will open in which you can select the desired data points. In addition, you can decide, which labelling type you prefer (percentage, absolute, or both) and if an ellipsis is to be placed around the value

If you want to adjust the settings at a later stage, simply click on the growth arrow and click Edit. The same selection window will open in which you can change the growth arrow settings. If you wish to delete the growth arrow from your presentation, select the arrow and click the Delete button.

CAGR Arrow

A CAGR (Compound Annual Growth Rate) arrow displays the annual average growth rate of the time period between two data points. To add a CAGR arrow click on Lines in the Action Bar and then select CAGR Arrow. A further window will open in which you can select the two data points. Similar to the growth arrow you can make changes or delete the CGR arrow by clicking on the element.

Delta Line

The delta line shows the percentage or absolute difference between two data points. To add a delta line, click on Lines in the Action Bar and select Delta Line (Figure 73). Select the data points in the menu that opens. In addition, you can decide, which labelling type you prefer (percentage, absolute, or both). And if an ellipsis is to be placed around the value. In order to delete the delta line, simply select it and click the Delete button.

Value Line

This feature displays a horizontal value line into your chart. In order to set up a value line, click on Lines in the Action Bar and select Value Line. A further section will open in which you can select the desired data points. In addition, you can label the value line. To adjust or delete the value line, simply select it make the appropriate changes or click the Delete button to remove the line from the chart.

Insert breaks

Breaks allow you to truncate data segments, e.g. to be able to better display smaller columns.

To add breaks, click on Lines in the Action Bar and select Value Axis or Category Break.

A further window will open in which you can set new breaks. The width (the hidden value section) of the break can be adjusted automatically or manually.

If you click on Automatic, automatic break logic will be used, which calculates the size of a break so that the expressiveness of the chart is optimally balanced. Individual series can also be explicitly exclude.

Sometimes you may use data in a chart that differs strongly in size. This may result in columns with lower values to be displayed next to columns with a high value which can result in a confusing chart. Breaks can help to maintain readability.

To the left is an example of a chart without a break, while the right chart has a break inserted:

Also, when selecting category break, a popup window will open, where you can set appropriate breaks.