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, type or color 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. Additionally, you are able to set not only a different Fill Color per series but also a different specific color per series when negative figures are used.


Moreover, a data chart can be configured so that colors will be adopted from Excel.


The closest CD-compliant color of the current empower charts customizing is used. This also works for any complex conditional formatting in Excel.




When opening the function, Data you have the possibility to further customize charts in relation to their series or categories.


Here you can set the serial reference of your chart either by rows or by columns of your Excel® data.

You can keep the series or category order of your chart with the one in Excel®or swap the order.

empower® will automatically apply these adjustments to your chart.

You can also use Data to create an Excel Link, which automatically adjusts your chart to the data of an external file.

If you wish to remove the link to the external data source, click on the action point Break link in the Action Bar above the chart. If you want to edit the Excel® link, select the option Edit link.


With a click on Open link source you can directly open the linked source and adjust it for the chart.


Editing category labels

For the category labels, you have the option to customize them.


Long category labels are now automatically wrapped.


If you want to create text breaks manually, you can do this directly in Excel® by pressing Alt and Enter.  

You can also change the text orientation or the vertical text orientation, so that the text remains manageable and does not overlap even with longer labels. To avoid such behavior, you can align the text at the top, center, or bottom.


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



Article is closed for comments.