Excel 2007 Pie Chart / Pie Graph Tutorial

Formatting the Pie Chart - 2

Excel 2007 Pie Chart

© Ted French

Formatting the Pie Chart - 2

Note: For help with these instructions, see the image example above.

Adding a title to the chart

1. Click on the Layout tab.
   
   
2. Click on Chart Title under the Labels section.
   
   
3. Select the third option - Above Chart.
   
   
4. Type in the title "The Cookie Shop 2003 Revenue from Sales"

Remove the legend

1. Choose Layout > Legend > None.

Adding data labels to the chart

1. Choose Layout > Data Labels > Best Fit to add data labels.
   
   
2. Choose Layout > Data Labels > More Data Label Options to bring up the Format Data Labels dialog box.
   
   
3. Remove the check marks from Value and Show Leader Lines under Label Options in the right hand window.
   
   
4. Check off Category Name and Percentage under Label Options in the right hand window.

• 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