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 . In the displayed Chart Wizard dialog box, under Chart type, click Pie. Under Chart sub-type, in the first row, click the second type, Pie with a 3-D visual effect. Compare your screen with Figure 2.36. Figure 2.36. |
3. |
In the Chart Wizard dialog box, click Next. |
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. |
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 pointer, and then drag the label slightly away from its pie slice to display its leader line. Repeat this technique on any label whose leader line is not displayed. |
10. |
Point to the Chart Title and click to select the title. From the Formatting toolbar, change the Font to Arial Black and the Font Size to 18. Click outside the chart to deselect, and then compare your screen with Figure 2.39. 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 your workbook. |
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. |
4. |
Delete Sheet2 and Sheet3, and then Save your workbook. |
[Page 735 (continued)] Objective 9 Print a Chart on a Separate Worksheet |
Windows XP
Outlook 2003
Internet Explorer
Computer Concepts
Word 2003
Chapter One. Creating Documents with Microsoft Word 2003
Chapter Two. Formatting and Organizing Text
Chapter Three. Using Graphics and Tables
Chapter Four. Using Special Document Formats, Columns, and Mail Merge
Excel 2003
Chapter One. Creating a Worksheet and Charting Data
Chapter Two. Designing Effective Worksheets
Chapter Three. Using Functions and Data Tables
Access 2003
Chapter One. Getting Started with Access Databases and Tables
Chapter Two. Sort, Filter, and Query a Database
Chapter Three. Forms and Reports
Powerpoint 2003
Chapter One. Getting Started with PowerPoint 2003
Chapter Two. Creating a Presentation
Chapter Three. Formatting a Presentation
Integrated Projects
Chapter One. Using Access Data with Other Office Applications
Chapter Two. Using Tables in Word and Excel
Chapter Three. Using Excel as a Data Source in a Mail Merge
Chapter Four. Linking Data in Office Documents
Chapter Five. Creating Presentation Content from Office Documents