Microsoft Office Tutorials and References
In Depth Information
EX 204
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?
chart title
underlined and
font size changed
3-D Pie chart
Certifi cation
The Microsoft Certifi ed
Application Specialist
(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
Certifi cation Web page
default color of
slices changed
data labels
changed to
month and
Chart Items
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
the item.
exploded slice
Figure 3–48
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.
Search JabSto ::

Custom Search