Excel 2007 Pie Chart / Pie Graph Tutorial

Entering the Chart Data

Excel 2007 Pie Chart

© Ted French

Enter the Chart Data

The first step in creating a pie chart is to enter the data into the worksheet.

When entering the data, keep these rules in mind:

1. Don't leave blank rows or columns when entering your data.
   
   
2. Enter your data in columns.
   • Note: When laying out your spreadsheet, list the names describing the data in one column and, to the right of that, the data itself.
   
   
   
3. A pie chart is a percentage chart, so only one series of data will be used in the chart. If there is more than one column of data, try to list the data to be used in the chart next to the column containing the list of names in order to simplify creating the chart.

To follow this tutorial, enter the data located in step 9.

• Create a Pie Chart / Pie Graph in Excel 2007
• Entering the Chart Data
• Select the Pie Chart Data
• Selecting a Pie Chart Type
• The Basic Pie Chart
• Formatting the Pie Chart - 1
• Formatting the Pie Chart - 2
• Formatting the Pie Chart - 3
• Pie Chart Tutorial Data