You can show the data labels or data values
within the chart so that the data values are more clear.
For example,
you can display the data values above each column in a column chart
to show the exact height of each column.
Procedure
- In the chart, under Series, select
the chart type icon.
- In the Properties pane, double-click
the Show values property.
- 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.
- To show lines pointing from data labels to the data marker
they apply to, select the Show 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 being 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 being closer to their corresponding data markers.
