Skip to end of metadata
Go to start of metadata

When creating a bar chart or bubble chart, data labels are hidden in the diagram by default. Data labels can make a chart easier to understand because they provide information about a data series. If data labels are activated, textual labels are shown in the chart.


Data labels shown in the bars of a bar chart


In a bubble chart you can also choose to show a number label instead of a textual label. Each bubble will be provided with a number, which will also be shown in the chart's legend.


      

Number labels (left) and text labels (right)


The slices of a pie chart show the absolute value of each slice and the percentage. Each slice is presented as a percentage of the whole diagram. You can also choose to show only one of them, or to hide them.


Display of only absolute values, only percentages, both, and none

Showing data labels in a bar chart or bubble chart

  1. Select the chart, and click  to open the chart's Settings window.

  2. On the Representation tab, click the cross  next to Data labels.

    In case of a bubble chart, select the desired label format: name or number.

  3. Close the Settings window.


If you have activated labels in a chart, but do not see them, the chart may be too small to display the labels. Enlarge the chart to make the labels visible.

Hiding data labels in a pie chart

  1. Select the pie chart, and click  to open the chart's Settings window.

  2. On the Representation tab, click the check mark  next to Show percentage and/or Show absolute value, depending on what you want to hide.

  3. Close the Settings window.

Positioning data labels outside of the pie

If labels are shown, they are positioned inside the slices of the pie. You can choose to position the labels outside of the pie.


  1. Select the pie chart, and click  to open the chart's Settings window.

  2. On the Representation tab, click the cross  next to Position label outside pie.

  3. Close the Settings window.