Microsoft Office Tutorials and References
In Depth Information
Adding a Pie Chart to the Worksheet
In this worksheet, the ranges to chart are the nonadjacent ranges A9:A16
(category names) and N9:N16 (yearly expense totals). The expense titles in the range
A9:A16 will identify the slices of the pie chart; these entries are called category
names . The range N9:N16 contains the data that determines the size of the slices in
the pie; these entries are called the data series . Because eight budget items are being
charted, the 3-D pie chart contains eight slices.
1 ENTER TEXT | 2 CALCULATE SUMS & USE FORMULAS | 3 SAVE WORKBOOK | 4 FORMAT TEXT
5 INSERT CHART | 6 NAME TAB | 7 PREVIEW & PRINT WORKSHEET
To Add a 3-D Pie Chart
Why? When you want to see how each part relates to the whole, you use a pie chart. The following steps draw the
3-D pie chart.
• Select the range A9:A16 to identify the range of the category names for the 3-D pie chart.
• While holding down the CTRL key, select the range N9:N16.
• Tap or click INSERT on the ribbon to display the INSERT tab.
• Tap or click the ‘Insert Pie or Doughnut Chart’ button (INSERT tab | Charts group) to display the Insert
Pie or Doughnut Chart gallery (Figure 1– 56).
Why does the ribbon display extra tabs?
Excel displays additional tabs that provide options for use when you are working with certain objects,
such as charts.
‘Insert Pie or
Insert Pie or
Figure 1– 56