Microsoft Office Tutorials and References
In Depth Information
Adding a 3-D Pie Chart to the Workbook
chart title underlined
and font size changed
to 28-point
3-D Pie chart
default color of
slices changed
data labels
changed to
month and
exploded slice
Figure 3 –51
Unlike the 3-D Column chart created in Chapter 1, the 3-D Pie chart shown
in Figure 3 – 51 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 B12:G12 (month
names) and B25:G25 (monthly operating incomes). The month names in the range
B12:G12 will identify the slices of the Pie chart; these entries are called category names .
The range B25:G25 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 142 also calls for
emphasizing the month of August by offsetting its slice from the main portion. A Pie chart
with one or more slices offset is called an exploded Pie chart .
As shown in Figure 3 – 51, 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.
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.
Search JabSto ::

Custom Search