Data Labels tab

The Data Labels tab is available in both the Formatting Data Series dialog and the Chart Options dialog. See these topics:

Data labels give information about a data series in addition to that provided by the axes and legend of a chart.

For example:

  • Display the precise value which a data series represents: Select Show value.
  • Display the name of the data which the data series represents. You might use this instead of displaying a chart legend. Select Show label.
  • Display both the value and name. Select Show label and value.

Some label options are only available for certain types of chart. For example, Show bubble size.

See chart types.

If you enable chart labels, the Format Data Labels dialog becomes available. See Format Data Labels dialog.