Excel 2007 Pie Chart / Pie Graph Tutorial

Select the Pie Chart Data

Excel 2007 Pie Chart

© Ted French

Two Options for Selecting the Chart Data

Using the mouse

1. Drag select with the mouse button to highlight the cells containing the data to be included in the pie chart.

Using the keyboard

1. Click on the top left of the pie charts's data.
2. Hold down the SHIFT key on the keyboard.
3. Use the arrow keys on the keyboard to select the data to be included in the pie chart.

Note: Be sure to select any column and row titles that you want included in the chart.

For this tutorial

1. Highlight the block of cells from A2 to B5, which includes the row headings.

• 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