Creating & Editing a Pie Chart in Excel

 

CREATING PIE CHART

 

  1. Highlight cells to be graphed.

FORMATTING GRAPH

 

  1. Size chart by moving corner black squares
  2. To edit category lettering, double click on any category label
  3. Format Data Box will show.  Format as you choose
  4. Click OK
  5. Double click on legend box to edit formatting.  When done formatting, click Next
  6. To change category color, click on chart once
  7. Pause
  8. Click on slice to change color
  9. Double click
  10. Edit each folder as you choose.
  11. Click OK
  12. Repeat 6-11 for each slice

 
  1. Click the Chart Wizard icon from the tool bar. 
  2. Chart Type – Click Pie
  3. Click Next
  4. Chart Source Data – click Next

  1. Chart Source Data – click Next
  2. Chart Options – click the folder Data Labels.
  3. Check Category name
  4. Check Value
  5. Click Title Folder
  6.  Type in your title
  7. Click Next
  8. Chart Location – (choose either one)
  9. Click Next

 

 

Created by Jackie Foltz - 2002