Excel Pie Chart / Pie Graph Tutorial

By Ted French, About.com Guide

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 2012 Revenue from Sales"

. Return to the format options list

Remove the legend

1. Choose Layout > Legend > None.

Return to the format options list

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.

Return to the format options list

Previous

• Create a Pie Chart / Pie Graph in Excel
• 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

Next