Edit Data Series Settings

If you have colored the cells in the chart's mini Excel according to your needs, you can use these colors to color the data series and data points in your chart.

Like this, you do not need to apply the colors individually via the user interface.

This also works if you have linked the chart to another Excel file via an Excel link.

To enable the color transfer from Excel, switch the toggle button for Excel Colors to On (Figure 744, “Toggle Button for Excel Colors”).

The colors will be transferred to your chart.

If you have not colored the cells in Excel, the customizing colors are used.

To reset the colors and not use Excel colors anymore, click on the button Reset Colors (Figure 745, “Button Reset Colors”).

For all data chart types, you can enable or disable series and adjust the series' colors.

To disable a series, untick the checkbox for the respective series (Figure 746, “Enable and Disable Series”).

The series is removed from the chart. You can always enable it again by ticking the respective checkbox.

The data is not lost nor deleted.

If only one series is left, the checkbox is ticked but grayed out. A chart cannot contain less than one series.

To adjust the fill color for a whole series, click on the painting bucket symbol under Fill Color in line with the respective series (Figure 747, “Set Fill Color”).

A color picker opens.

Here, choose the color you want to use (Figure 748, “Color Picker”).

If you do not want to use a fill color, choose the option No Fill.

The series will be colored in the respective color.

By default, there is no specific color for negative data points. However, you can choose a different color for those data points inside a series.

To do so, click on the painting bucket symbol under Fill Color if Negative in line with the respective series (Figure 749, “Set Negative Fill Color”).

A color picker opens.

Here, choose the color you want to use. If you do not want to use a fill color, choose the option No Fill.

All data points inside the series with a negative value will be colored in the respective color.

If you want to go back to the original customizing colors, click on the button Reset Colors.

In column charts and line charts, you can set the type for a series.

Here, you can decide if you want to display a data series as columns or lines.

To change the type of a series, expand the drop-down menu under Type in line with this series and choose the type you want to use (Figure 750, “Define Series Type”).

The changes will be applied to the chart.

If you want to create a mixed chart (bars or columns and lines) and work with two axes, empower^® automatically ensures that columns are only on one of the two axes.

The bars or columns would otherwise overlap and lead to misinterpreted representations.

You can always change back to the original series type.

If your chart is capable of displaying two value axes, you can also decide which axis the series should refer to.

To do so, expand the drop-down menu under Axis in line with the respective series and choose the axis you want to use (Figure 751, “Choose Axis”).

If you choose an axis which has not been enabled before, it is automatically enabled upon selection.

One series must always refer to the primary value axis. This series can then also not be disabled anymore.

If only the primary axis is selected for all series, the secondary is automatically disabled.

If you are displaying two value axes, the button Swap Axes becomes visible (Figure 752, “Button Swap Axes”).

Use this button to switch the axes and display the primary value axis as secondary value axis and vice-versa.

For waterfall charts, you have the additional option to place a series on top of the waterfall.

This is only possible if the chart contains more than one series.

To do so, tick the checkbox for On Top of Waterfall in line with the respective series (Figure 753, “Move Series on Top of Waterfall”).