Adapting charts

Data labels

Click on Data Labels in the Action Bar in order to change properties as well as data values and labels.


When working with column and bar charts, you have the possibility to decide if you wish to display the column sums in the chart. When working with grouped charts you can activate Show data labels outside instead. Values are then not displayed within the column or bar, but outside of it.


You also are able to display value labels by clicking on Value label and then clicking on Show Value. If you wish to display the values as percentages, please toggle the respective switch. If you wish to display the values as absolute values, please toggle the respective switch. The drop-down menu below allows you to select the decimal place of the percentage. Finally, you can display or hide the series name by toggling the switch. In order to maintain readability of data labels on a similar colored background, you can generate a transparent background for the labels by switching on Show data label background. You can always reset data labels to their original formatting by clicking Reset Data Labels.

When working with column or bar charts, you additionally have the option to display negative column or bar sums at the other end of the column or bar. Just activate Show negative sums at the other end. To do so, you need to activate the option Show column sums.


By default, the numeric format of the chart is based on the Excel® chart it is linked to. Using the respective drop-down menu, you can change the numeric format (e.g. to change from a European to an American radix format) (Figure 23).


You have the option to select predefined formats or create one of your own. If you click on Custom Number Format a window will open in which you can select the desired format or define your own in the entry field provided. Here, you are also able to display a specific percentage of a chart. Finally, you are able to change the scaling of values in order to better display large numbers.


You can also access the menu Value label via Data labels.


Here you can decide whether the value should be displayed in the chart, whether this value should be displayed as absolute or percentage value and whether the series names should be displayed. If you decide to display the values as a percentage, you can also define the decimal places.



Data series

Clicking the Series button in the Action Bar allows you to either select the axis or type of each series of a chart. In the Axis section you are then able to set if the series is to orientate itself to the primary of the secondary axis. When using bar charts, you can also click Type to set if the data series is to be displayed as a line or a bar. This way a hybrid chart can be compiled using lines as well as bars. In addition, you have the option to activate or deactivate visibility of a series. If you do not wish to display a certain data series in your chart, simply uncheck the option Visible.


Please note:
If you want to create a mixed chart (bars and lines) and work with two axes, make sure that all bar series are assigned to one axis. If there are series of bars on both axes, they overlap and lead to difficult to interpret charts (which tend to look incorrect).


Adapting data labels

To change the design of text elements in terms of caption or position, please select the desired element.

An overlay will appear in which font size and color may be adapted in accordance to corporate design. You can also select text formatting options such as Bold, Italics, and Underlined. Multiple elements of data labels can be selected and edited simultaneously. To do so, select the desired elements while holding Ctrl.


If you wish to change the position of the element, move it via Drag & Drop. The position of data labels automatically adapts to its environment, e.g. when they would otherwise overlap. To deactivate this automation, you are able to move the data label via Drag & Drop while holding the Ctrl button on your keyboard in order to place the element to its desired location. In order to move data labels exclusively horizontally and vertically, hold the Shift key while moving the element to the desired location. Even after larger changes to the underlying data displayed by the chart, the relative position of this manually moved data label will remain the same.

You also have the option to add a prefix before or a postfix after the data labels of a chart. Click on a data label, and the click either the Prefix or Postfix button. You can now enter your text and then click OK. For example, should you wish to remove the prefix, you can do so by selecting one of the data labels and after clicking the prefix button select Clear. A removal of the postfix is performed in a similar manner.



Changing chart elements

empower® charts allows you to change chart colors of a series as well as of a single element while keeping in line with corporate design. To do so, select the desired element of a series and then click the Color button to select a color.


If the selected element is part of a series, all elements of this series will adapt automatically. If you wish to change just a single element, do so by selecting the element with a double click and then make the desired changes.


In addition, you can a shading to empower® charts elements by selecting the element and clicking the Shading button. Now you can select a pattern.



Have more questions? Submit a request



Please sign in to leave a comment.