Microsoft Office Tutorials and References
In Depth Information
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%).
Plan
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 .
Charts
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
Certiﬁ cation
The Microsoft Certiﬁ 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
Appendix G or visit the
Excel 2007 Certiﬁ cation
Web page (scsite.com/
ex2007/cert).
default color of
slices changed
data labels
changed to
month and
percentage
exploded slice
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.
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