Microsoft Office Tutorials and References
In Depth Information
Two of the advanced pie chart subtypes are surprisingly useful when you want to tell a
story within a story. It’s also a good way to create a readable chart when you have a dozen
or more data points. The Pie Of Pie and Bar Of Pie subtypes let you combine two or more
slices into a single slice called Other, with those data points plotted in a second pie or bar
chart. Figure 13-10 shows the Bar Of Pie chart subtype.
Figure 13-10 You define which values go in the bar chart on the right by setting a condition—in
this example, all values less than 12 percent.
The options for the second chart are well hidden on the Series Options tab of the Format
Data Series dialog box. Click the chart, select the series from the drop-down list at the far
left of the Layout tab, and then click Format Selection. Use the sliders under the Gap Width
and Second Plot Size headings to adjust the distance between the two charts and change
their size relative to each other. The Split Series By options at the top of the dialog box
allow you to define which pieces of the original pie are broken out into the second chart.
A bar chart is, in its simplest form, a column chart turned on its side, with the values on the
horizontal axis and categories on the vertical axis. Bar charts are ideal for differentiating
winners and losers—or at least those who are in the lead for now. Bar charts work equally
well for presenting results of speed tests and for pointing out who’s in a front in a
fundraising competition. In Figure 13-11, for example, we could have just as easily plotted this data
as a column chart, but the long school names would have been awkward to position along
the horizontal axis and look more natural and readable here.