Saylor URL: http://www.saylor.org/books
Click the OK button on the Edit Series dialog box.
Repeat steps 5 through 9 for each data series that you need to add to the chart.
Click the Edit button on the right side of the Select Data Source dialog box.
Highlight the range of cells that contain the descriptions for the X axis.
Click the OK button on the Axis Labels dialog box.
Click the OK button on the Select Data Source dialog box.
Percent of Total: Pie Chart
Follow-along file: Continue with Excel Objective 4.00. (Use file Excel Objective 4.06 if starting here.)
The next chart we will demonstrate is a pie chart. A pie chart is used to show a percent of total for a data
set at a specific point in time. The data we will use to demonstrate a pie chart is related to the overall
spending activity in the health-care industry. The Health Care worksheet contains data that shows total
spending in the United States for the years 1969 and 2009. In 1969, the total amount spent in the United
States for health-related expenses was over $66 billion. The pie chart shows how this $66 billion was
funded. The following steps explain how to accomplish this:
Highlight the range A2:B7 on the Health Care worksheet.
Click the Insert tab of the Ribbon.
Click the Pie button in the Charts group of commands.
Select the “Exploded pie in 3-D” option from the drop-down list of options.
Click and drag the pie chart so the upper left corner is in the middle of cell E2.
Resize the pie chart so the left side is locked to the left side of Column E, the right side is locked to the
right side of Column M, the top is locked to the top of Row 2, and the bottom is locked to the bottom
of Row 17 (see Figure 4.18 "Pie Chart Moved and Resized").