Microsoft Office Tutorials and References
In Depth Information
Where’s the Pie Chart?
Where’s the Pie Chart?
Good question. I’ve omitted that chart type quite intentionally here because of the
observation I made in Table 6–2, back when I defined a pie chart. Pie charts can only
capture data one data series at a time, and our data has three series—Soc., Poli. Sci., and
Phil. You could construct a pie chart of only Walt’s grades, for example, as in Figure 6–18.
Figure 6–18. The higher the grade, the larger the slice
Here Walt’s grades are treated as a data series (we’ll look past the question of whether
grades are the sort of thing you’d best portray with a pie chart; but just note that it can
be done)—and that means if we’re pie-charting Walt’s grades, we can’t chart Sally’s,
Brian’s, and Ann’s as well on the same chart. Pie charts treat their slices as parts of one
whole—and that whole consists of one data series.
NOTE: The pie chart automatically adds a title to the chart. You’ll soon see how you can add a
title to any chart.
Changing the Default Chart
What you should have learned from this exercise is that the standard column chart
shown previously serves as Excel’s default chart. After all, we didn’t select that chart
when we pressed F11; Excel chose it for us. But what if you want to see a different chart
by default?
It’s easy. Recall that when
you execute the Change
Chart Type sequence you
trigger the dialog box shown
Search JabSto ::

Custom Search