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.
|
1. |
Select the nonadjacent ranges A3:A9 and E3:E9 to select the item names and the total retail value of each item. Alternatively, in the Name Box, type a3:a9,e3:e9 and press
|
|
2. |
Click the Chart Wizard button
Figure 2.36. |
|
3. |
In the Chart Wizard dialog box, click Next.
The labels are shown in a legend that uses color codes to relate the label to the pie slice. If you plan to print a chart on a printer that does not print in color, it is better to label each pie slice individually rather than use a legend.
|
|
4. |
In the Chart Wizard dialog box, click Next. Click the Titles tab. In the Chart title box, type Percent of Total Retail Value and then click the Legend tab. Clear the Show legend check box.
|
|
5. |
Click the Data Labels tab. Under Label Contains, select the Category name check box and the Percentage check box. Confirm that the Show leader lines check box is selected, and then compare your screen with Figure 2.37.
Figure 2.37. (This item is displayed on page 732 in the print version) The Chart Wizard calculates the percentage of the total and displays the percentage next to each slice. The Chart Wizard formats the percentages with no decimal places. This is an alternative to calculating the percentages in a separate column in the worksheet; however the worksheet is a better place to display percentages with more decimal places. A leader line is a line that connects the label in a chart to the pie slice. Excel uses leader lines to connect labels to the slices where the slices are too narrow to display the labels close to the slices.
|
|
|
|
|
6. |
In the Chart Wizard dialog box, click Next. Under Place chart, click the As new sheet option button. In the box to the right, type Percent of Retail Value Chart and then click Finish.
The chart is created on a separate worksheet named Percent of Retail Value Chart. Leader lines display if the pie slice is too narrow to accommodate the labels.
|
|
7. |
If the Chart toolbar displays, close it. In the displayed chart worksheet, point to the slice labeled Polo Shirts 23%, and notice that the ScreenTip displays the value upon which the percentage is based.
|
|
8. |
Click any of the chart's labels to select all of the labels. Then click any label that does not display a leader line to surround the label with a patterned box as shown in Figure 2.38.
Figure 2.38. |
|
9. |
Point to the border of the selected label to display the
|
|
10. |
Point to the Chart Title and click to select the title. From the Formatting toolbar, change the Font
Figure 2.39. (This item is displayed on page 734 in the print version) Each element of the chart can be formatted using similar methods.
|
|
|
|
|
11. |
Save
|
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
|
|
[Page 735 (continued)] Objective 9 Print a Chart on a Separate Worksheet
|