Numbers Tab (Chart Options)
When you enable the display of data labels in the Data Labels tab of Chart Options, you can select different kinds of information to display:
- For Area, Bar, Column, Line, Numeric Axis, and Radar charts, you can select Value, Label, or Label & Value. If you selected Label, the chart will show series labels only and you cannot format them as numeric values even if the series labels are numbers. If you selected Value or Label & Value, you can format these values using the Numbers tab in Chart Options.
- For Bubble charts, you can select "(X,Y) Value" or "(X,Y, Bubble Size)." Only the Bubble Size values can be formatted using the Numbers tab in Chart Options. (X,Y) Values always use the number format selected for the X- and Y-axis labels.
- For Scatter charts, the Number tab is not included in the Chart Options dialog box. The data labels use the same format and the X- and Y-axis labels.
Use the Numbers tab to format data label numbers. See Numeric Axis Grids and Scales Dialog Box if you want to format numbers that appear on a numeric axis (Y1, Y2, or X).
See Also
Data Labels Tab | Chart Options Dialog Box