Showing data labels or values in charts
You can show the data labels or data values within the chart so that the data values are clearer.
For example, you can display the data values above each column in a column chart to show the exact height of each column.
- For a bar, column, line, or area chart, under Series, select the chart type icon.
- For a bubble, scatter, Pareto, or progressive chart, click the chart.
- In the Properties pane, under Chart Labels, double-click the Show Values property.
- For bar, column, line, area, Pareto, or progressive charts,
to specify the data label format, in the Values list,
select what values to display.
- None does not display data values.
- Values displays the non-cumulative value of the data.
- Cumulative values displays the cumulative value of the data.
- For bubble or scatter charts, to specify the data label format, in the Show box, select whether to show values or values and labels for the category, series, and measure.
- For bar, column, line, area, Pareto, or progressive charts, to show lines that point from data labels to data marker they apply to, select the Show leader lines check box.
- For bubble or scatter charts, to show lines that point from data labels to data marker they apply to, select the Leader lines check box.
- To specify where values and labels are to be rendered in the chart, click the Value Location list and choose the location that you want.
- To specify how to display the labels if their positions
on the chart overlap, in the Collision Mode list,
click one of the following modes:
- None specifies that labels appear in default positions and might overlap.
- Normal (for pie and donut charts) specifies that labels are placed just above their corresponding data markers or chart objects. There is no collision detection, so labels can overlap.
- Coarse Stagger specifies that labels are placed close to their data markers and staggered so that they do not overlap. This collision mode takes less time to render than Fine Stagger but might result in labels that are farther away from their corresponding data markers.
- Fine Stagger specifies that labels are staggered so that they do not overlap. The labels are as close to the data markers as possible without overlapping. This collision mode takes more time to render than Coarse Stagger but might result in labels that are closer to their corresponding data markers.