Data Labels Tab (Chart Options)
Data labels show the actual values of each chart cell. Use the Data Labels tab to add data labels to your chart. Selectable data label values and locations will be slightly different depending on the chart type. Data labels are not available in 3D Surface charts.
- Show Data Labels
- You can show or hide data labels for all series in a chart or for a single series in a chart. Select this check box to show or hide data labels for all series in the chart.
- Labels Location
- When the Show Data Labels check box is selected, choose an option from this list box to select where the data labels are displayed next to their associated riser in the chart. This option is not available for True 3D charts.
- Label Format
- For area, bar, column, and line charts, choose the Value selection to show the values from the data sheet at the corresponding location on each riser. If Label is selected, the series labels are drawn. If Label & Value is selected, the series labels and the value from the data sheet will be shown.
For bubble charts, if (X,Y) value is selected, the first two values (X and Y position) that define each data point will be drawn for each bubble marker. If (X,Y, Bubble Size) is selected, the X-position, Y-Position, and Size values will be shown. This selection is not available for Scatter charts or True 3D charts.
- Show as Percentage
- If you selected a Label Format of Value or Label & Value in a percent or stacked chart, select this check box to show the percentage value that each riser represents.
- Cumulative Values
- If you selected a Label Format of Value or Label & Value in a percent or stacked chart, select this radio button to show the cumulative value of each riser.
- Absolute Values
- In percent and stacked area charts, select this radio button to show the absolute value of each riser. You must have also selected either Value or Label & Value in the Label Format field.
- Show Total
- If you selected Absolute Values, select this check box to show the total value of each category of risers.
Funnel Charts
Data labels can be used to show the actual values from your data. You can show the value associated with each funnel slice, or the values as a percentage of the whole. You can position this information on the funnel slice or outside each slice.
- Show Values
- Select this check box to show or hide data label values for each slice in the funnel chart.
- Show Values As Percentage
- If Show Values is selected, select the check box to show the data values as a percentage of the total. Do not select this check box to show the absolute value that defines each slice.
- Values on Slices / Values outside Slices
- If Show Values is selected, select one of these radio buttons to display the data values on each funnel slice or outside each funnel slice.
- Show Labels
- Select this check box to show or hide the series label associated with each funnel slice.
- Labels on Slices / Labels outside Slices
- If Show Labels is selected, select one of these radio buttons to display the labels on each funnel slice or outside each funnel slice.
- Show Leader Lines
- If Show Values and the "Labels outside Slices" radio button is selected, or if Show Labels and the "Values outside Slices" radio button is selected, use this check box to show or hide leader lines from each funnel slice to the data value displayed next to it.
Pie or Doughnut Charts
Data labels can be used to show the actual values from your data. You can show the value associated with each pie slice, the series label only, or the value and the series label. You can position this information on the pie slice or outside each slice.
Note You can also show or hide and format data labels for an individual series in a chart.
- Show Values
- Select this check box to show or hide data label values for each slice in the pie chart.
- On Slices / Outside Slices
- If Show Values is selected, select one of these radio buttons to display the data values on each pie slice or outside each pie slice.
- As Percentage
- If Show Values is selected, select the check box to show the data values as a percentage of the total. Do not select this check box to show the absolute value that defines each slice.
- Show Labels
- Select this check box to show or hide the series label associated with each pie slice.
- On Slices / Outside Slices
- If Show Labels is selected, select one of these radio buttons to display the series labels on each pie slice or outside each pie slice.
- Show Leader Lines
- If Show Values and the Outside Slices radio button is selected, or if Show Labels and the Outside Slices radio button is selected, use this check box to show or hide leader lines from each pie slice to the data value and/or series label displayed next to it.
- Labels on Sides
- Select this check box to draw labels on the sides of the pie chart.
See Also
Chart Options Dialog Box