Microsoft Office Tutorials and References
In Depth Information
Pie Charts
easier to find the value associated with each entry on the horizontal axis. You can
customize the color and shape of each marker, and those customizations appear automatically in
the legend, as in this example.
INSIDE OUT Add data labels selectively
Adding data labels to every point in a series can sometimes lead to information
overload. The alternative is to add data labels to specific data points. Click to select the
data series, and you’ll see a selection marker over every point in the series. Click any
individual data point to select just that point. Now you can show or hide the label for
that point alone. Use the options on the Data Labels menu, in the Labels group on the
Layout tab, to choose a position for the label, or drag it manually. In Figure 13-8, we
used a total of four data labels to identify the two peaks and two valleys on the
individual lines.
Pie Charts
If the data you want to plot is in a single row or column, it just might it in a pie chart. Each
pie chart consists of a single data series. Each data point is a slice proportional in size to the
other items in the series, adding up to 100%. Pie charts work best when you have a small
number of data points, six or seven at most, and no slice is too close to 0. (Negative
numbers aren’t allowed in a pie chart.)
The Data Labels option on the Layout tab allows you to position the data labels (try the
Best Fit option). To customize the data displayed—to show percentages instead of values or
vice versa—click More Data Label Options, which opens the Format Data Labels dialog box
with the Label Options tab selected, as shown in Figure 13-9.
Search JabSto ::




Custom Search