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 bubble in a bubble chart
to show the exact value of each bubble.
You can show data values
for the following chart types: Pareto, progressive, scatter, and bubble.
Procedure
- Select the chart.
- In the Properties pane, double-click
the Show values property.
- For each of the categories, series, and measures, select
whether to show only values, values and labels, or neither.
- To show lines pointing from data labels to the data marker
they apply to, select the Show leader lines check
box.
- 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.
