Data Labels

Data labels provide additional information about specific data points.

Tip

  • The Chart Options dialog enables you to set data labels for all chart points. To set data labels for just a single data series or data point, select the series or point, then use the Format dialog, which I tell you about later in this chapter.

To set data labels

1.
In the Chart Options dialog, click the Data Labels tab to display its options (Figure 52).
2.
Select one of the Data labels radio buttons:
  • None removes all data labels.

  • Show value displays the value for each data point.

  • Show percent displays the percentage of the whole for each data point. This option is only available for pie and doughnut charts.

  • Show label displays the legend label for each data ...

Get Microsoft Excel X for Mac OS X: Visual QuickStart Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.