Microsoft Office Tutorials and References
In Depth Information
Excel Chapter 3 What-If Analysis, Charting, and Working with Large Worksheets
Adding a 3-D Pie Chart to the Workbook
The next step in the chapter is to draw the 3-D Pie chart on a separate sheet in the
workbook, as shown in Figure 3–48. Use a Pie chart to show the relationship or
proportion of parts to a whole. Each slice (or wedge) of the pie shows what percent
that slice contributes to the total (100%).
Specify how the chart should convey necessary information.
The 3-D Pie chart in Figure 3–48 shows the contribution of each month’s projected operating
income to the six-month projected operating income. The 3-D Pie chart makes it easy to
evaluate the contribution of one month in comparison to the other months.
Unlike the 3-D Column chart created in Chapter 1, the 3-D Pie chart shown in Figure 3–48
is not embedded in the worksheet. Instead, the Pie chart resides on a separate sheet, called
a chart sheet , which contains only the chart.
In this worksheet, the ranges to chart are the nonadjacent ranges B3:G3 (month names)
and B16:G16 (monthly operating incomes). The month names in the range B3:G3 will identify
the slices of the Pie chart; these entries are called category names . The range B16:G16 contains
the data that determines the size of the slices in the pie; these entries are called the data
series . Because six months are being charted, the 3-D Pie chart contains six slices.
The sketch of the 3-D Pie chart in Figure 3–3b on page EX 166 also calls for emphasizing the
month of June by offsetting its slice from the main portion. A Pie chart with one or more
slices offset is called an exploded Pie chart .
You are aware that,
when you change a
value on which a chart
is dependent, Excel
immediately redraws the
chart based on the new
value. Did you know
that, with bar charts, you
can drag the bar in the
chart in one direction or
another to change the
corresponding value in
the worksheet, as well?
font size changed
3-D Pie chart
The Microsoft Certiﬁ ed
(MCAS) program provides
an opportunity for you
to obtain a valuable
industry credential – proof
that you have the Excel
2007 skills required by
employers. For more
information, see Appendix
F or visit the Excel 2007
Certiﬁ cation Web page
default color of
When you rest the
mouse pointer over
a chart item, such as
a legend, bar, or axis,
Excel displays a chart tip
containing the name of
As shown in Figure 3–48, the default 3-D Pie chart also has been enhanced by rotating
it, changing the colors of the slices, adding a bevel, and modifying the chart title and labels that
identify the slices.