Edit Data Chart Objects

For data points, you can decide if you want to display the label or not.

To display data labels, select the data point and click on the button Show Label (Figure 786, “Button Show Label for Data Points”).

If your chart contains columns, you can also decide if you want to display column sums.

To display column sums, select the data point and click on the button Show Column Sums (Figure 787, “Button Show Column Sums for Data Points”).

To change the color of a data point, select the data point and click on the button Colors (Figure 788, “Button Colors for Data Points”).

Then, select a color or choose the option No Fill if you do not want to apply a fill color.

To change the pattern of the data point, select the data point and click on the button Pattern (Figure 789, “Button Pattern for Data Points”).

Then, choose a pattern for the data point.

For column, bar and circle charts, you can also edit the data points' border.

To do so, select the data point and click on the button Edit Line Style (Figure 790, “Button Edit Line Style for Data Points”).

Here, choose a color.

If you have selected a color, you can change the dash style and weight of the border (Figure 791, “Options for Borders”).

If you do not want to display a border at all, choose the option No Border.

To reset the border style to the initial border style, click on the button Reset.

In line, scatter, bubble and radar charts, you can edit the marker points.

In line and radar charts, you can additionally edit the line between the data points.

For the marker points, you can decide if you want to display a label.

To display a label, click on the button Show Label (Figure 792, “Button Show Label for Marker Points”).

In addition, you can change the color of the marker point.

To do so, click on the button Colors and choose a color (Figure 793, “Button Colors for Marker Points”).

To change the marker's shape, click on the button Marker Style and choose a new shape (Figure 794, “Button Marker Style for Marker Points”).

If you do not want to display any markers, choose the option None.

To change the size of the marker point, either type in a new value into the input field or use the arrow symbols to increase or decrease the value (Figure 795, “Increase Or Decrease Marker Point Size”).

In bubble charts, you also have the option to bring the data point's bubble to the front in case it is overlapping another bubble.

To do so, click on the button Bring Bubble to Front (Figure 796, “Button Bring Bubble to Front”).

For lines between data point, you can also change the color.

To do so, click on the button Colors and choose a color.

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

To change the dash style of the line, click on the button Dash Style (Figure 797, “Button Dash Style for Data Point Lines”).

Here, choose a style.

To display the line thicker or thinner, either type in a new value into the input fields or use the arrow symbols to increase or decrease the value (Figure 798, “Increase Or Decrease Data Point Line Weight”).

For pie charts, you have additional options.

You can rotate the pie chart using the rotation symbol in the center above the chart (Figure 799, “Rotate Pie Chart”).

To do so, drag and drop the symbol until you have reached your preferred position.

In addition, you can pull out a data point to highlight it (Figure 800, “Pull Out Data Point”).

To do so, select the data point and pull it out of the chart.

Its data label is moved accordingly.

For data series, you have the same options as for the respective data points (Figure 801, “Data Series Settings”).

However, you cannot enable the column sums for a data series. This setting needs to be enabled and disabled for each data point separately or globally for all series and points via the button Data Labels.

If you select a data series in line or radar charts, your options for data point markers and the line between them are combined (Figure 802, “Data Series Settings for Line and Radar Charts”).

For all axes in your chart, you can make changes to the text formatting and appearance of the axis.

To edit the font size, font color and formatting of the axis labels globally, select the axis and make your changes.

All labels in the axis adjust to your changes.

In addition, you can add an axis title to each axis. To do so, select the axis and click on the button Show Axis Titles (Figure 803, “Button Show Axis Titles”).

Then, you can adjust the title text and formatting. To do so, select the title.

For category axes, you can also edit the text direction, alignment and category order.

To change the text direction, click on the button Text Direction and choose your preferred option (Figure 804, “Button Text Direction”).

To change the alignment, click on the button Align Vertically and choose your preferred option (Figure 805, “Button Align Vertically for Horizontal Axes”).

In vertical category axes, you can choose the alignment option directly in the menu (Figure 806, “Alignment Options for Vertical Axes”).

Long category labels are wrapped automatically. To create a soft line break manually, press Shift + Enter.

To change the category order, click on the button Categories Order Reversed (Figure 807, “Button Categories Order Reversed”).

In column Mekko and Marimekko charts, you have additional options for the category axis.

To view those options, select the axis and click on the button Settings (Figure 808, “Button Settings for Mekko Charts”).

Here, you can decide if you want to display the name, the values or the percentages as labels (Figure 809, “Mekko Chart Options for Category Axes”).

If you choose to display percentages, you can also decide on how many decimal places you want to display.

You can enable multiple options at once.

If you disable all of them, the axis stays empty.

To delete an axis, select it and then click on the button Remove (Figure 810, “Button Remove for Axes”).

If you have enabled the chart title via the button Properties in the action bar, you can edit this title according to your needs.

To edit the chart title text, click into the text field and type in the title you want to use.

To display the chart title in two rows, use the keyboard shortcut Ctrl + Enter to create a soft line break (Figure 819, “Example – Title in Two Lines”).

Subscript or superscript can also be used in chart titles.

To do so, use \sup{text} for superscript or \sub{text} for subscript and replace {text} with your text you want to format with superscript or subscript.

To edit the chart title formatting, select it.

A menu opens (Figure 820, “Menu for Chart Title”).

In this menu, you can define the font size, font color, formatting and text alignment.

To change the chart title text freely, click on the button Modify Label Freely (Figure 821, “Button Modify Label Freely for Chart Title”).

You then enter free text formatting mode automatically.

In addition, you can move the chart title to your preferred position.

To drag it freely, press Alt + Ctrl.

The chart title cannot be dragged out of the chart area.

To delete the chart title, click on the button Remove (Figure 822, “Button Remove for Chart Title”).

If you have inserted a legend via the button Properties in the action bar, you can edit this legend according to your needs.

The position of the legend can be changed in the properties menu and directly via the legend.

To do so, select the legend and click on the button Legend Position (Figure 823, “Button Legend Position”).

If you want to revert the order of the legend entries, select the legend and click on the button Revert Legend Entry Order (Figure 824, “Button Revert Legend Entry Order”).

In the same menu, you can also change the font size and color as well as the formatting globally for all legend texts (Figure 825, “Formatting Options for Legend Labels”).

If you change the font size of legend texts, the legend icon size adapts accordingly.

To enlarge the legend, select the legend and hover over its border.

A bilateral arrow appears. Drag and drop this arrow to adjust the size of the legend (Figure 826, “Enlarge Or Shrink Legend”).

In addition, you can access all data series settings via the legend icon (Figure 827, “Data Series Settings in Legend”).

These settings will be applied to all data points in a series and will then be reflected in the legend.

To do so, select the legend icon and make your changes.

The legend icon labels can also be formatted individually.

To delete a legend entry, select the legend icon and click on the button Delete.

The entry is deleted from the legend. The corresponding series will not be deleted or hidden from the chart.

If you have added lines or arrows via the button Lines in the action bar, you can edit these arrows and lines according to your needs.

For most of them, you can edit the label text and label formatting (Figure 828, “Formatting Options for Arrow and Line Labels”).

In addition, you can edit the color of most arrows and lines.

For some and arrows, you can also choose the dash style and line weight.

If you are displaying ellipse, you can choose a fill color for them.

If you are currently displaying an ellipse for the line or arrow, a second button Colors is displayed. This button displays a painting bucket symbol (Figure 829, “Button Colors for Ellipse”).

Click on this button to choose a fill color for the ellipse.

If you do not want to display any color, choose the option No Fill.

To change the color of a line or an arrow, select it and click on the button Colors with the pen symbol (Figure 830, “Button Colors for Lines and Arrows”).

Here, choose a color.

For value lines, you can also change the dash style and line weight (Figure 831, “Options for Value Lines”).

To change the dash style, click on the button Dash Style and choose a style.

To change the line weight, click on the button Weight and select a weight.

To reset the arrow or line style to the initial style, click on the button Reset.

To change the label of an arrow or line freely, click on the button Modify Label Freely (Figure 832, “Button Modify Label Freely for Arrows and Lines”).

You then enter free text formatting mode automatically.

To delete a line or an arrow, select it and click on the button Delete (Figure 833, “Button Delete for Arrows and Lines”).