Microsoft Office Tutorials and References
In Depth Information
This type of problem can sometimes be solved by rotating or changing the
elevation of the 3-D chart to provide a different view. In some cases, plotting
the series in reverse order will reveal the obscured data. For the most
control, you can manually change the plot order of the series. These procedures
are described in Chapter 4.
A doughnut chart is similar to a pie chart, with two exceptions: It has a hole in the
middle and it can display more than one series of data. Figure 2-18 shows an
example of a doughnut chart with two series (1st Half Sales and 2nd Half Sales).
The legend identifies the data points. The arrows and series descriptions were added
manually. A doughnut chart does not provide a direct way to identify the series!
Notice that Excel displays the data series as concentric rings. As you can see, a
doughnut chart with more than one series can be very difficult to interpret. For
example, the relatively larger sizes of the slices toward the outer part of the doughnut
can be deceiving. Consequently, doughnut charts should be used sparingly. In many
cases, a stacked-column chart for such comparisons expresses your meaning better
than does a doughnut chart.
Figure 2-18: A doughnut chart with two
Perhaps the best use for a doughnut chart is to plot a single series as a visual
alternative to a pie chart.
Table 2-8 lists Excel’s two doughnut chart subtypes.