# Objective 8. Make Comparisons Using a Pie Chart

Pie charts are used to show the relationship of each part to a whole. To create a pie chart, you must select two ranges. One range contains the labels for each slice of the pie chart, and the other range contains the values that add up to a total. The two ranges must have the same number of cells and the range with the values should not include the cell with the total. You can use a legend to identify the slices of the pie using colors, but it is usually more effective to place the labels close to each pie slice.

Activity 2.14. Creating a Pie Chart

The purpose of the Golf Course Pro Shop Inventory worksheet is to determine how each item contributes to the total retail value of the inventory. To display the relationship of parts to a whole, use a pie chart. In the worksheet, you calculated the percent of the total in column F. Alternatively, this percentage can be calculated by the Chart Wizard and added to the chart as a label.

Activity 2.15. Moving Worksheets

Within a workbook, you can rearrange the order of the worksheets.

 1. Click Sheet1 to make it the active worksheet, and then rename the worksheet tab Inventory Data 2. Click the Percent of Retail Value Chart sheet tab to make it the active sheet, then point to the same sheet tab, hold down the left mouse button until a sheet icon displays. Compare your screen with Figure 2.40.   Figure 2.40. (This item is displayed on page 735 in the print version) When you see the sheet icon, you can drag to move the selected sheet to the left or right of the other sheet tabs. 3. Drag the Percent of Retail Value Chart sheet icon to the right of the Inventory Data sheet tab, and as you move, notice the tiny trianglecalled a caretthat indicates the location where the worksheet will be positioned, and then release the mouse button. The chart sheet is positioned to the right of the Inventory Data sheet. 4. Delete Sheet2 and Sheet3, and then Save your workbook.

[Page 735 (continued)]

### Objective 9 Print a Chart on a Separate Worksheet

GO! with Microsoft Office 2003 Brief (2nd Edition)
ISBN: 0131878646
EAN: 2147483647
Year: 2004
Pages: 448