1. Computing

Excel Pie Chart / Pie Graph Tutorial

By , About.com Guide

7 of 9

Formatting the Pie Chart - 2
Excel Pie Chart

Excel 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 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

©2013 About.com. All rights reserved.