Adapting charts

Data labels

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


You now 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. Values are then not displayed within the column or bar, but outside of it.

You also are able to display value label by clicking on Show Value. If you wish to display the values as percentages, 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”. 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). 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.

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.

Adapting text elements

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. 

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.