How to Do a Pie Chart on Excel

Written by hunter taylor
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Do a Pie Chart on Excel
Use pie charts to show how each component contributes to the whole. (Ablestock.com/AbleStock.com/Getty Images)

Microsoft Excel has readily usable charting/graphing capabilities. Previous versions of Excel had a wizard to guide you through creating a pie chart. More recent versions of Excel allow you to highlight the data to include in the chart/graph and press a few buttons to create it. The pie chart will show how each part of the data contributes to the whole.

Skill level:
Moderate

Other People Are Reading

Instructions

  1. 1

    Enter the months of January through December in column A, for example. In column B, enter the electricity bills for each month. The pie chart will show each month's percentage of the year's electricity bill. This data can be actual or fictitious.

  2. 2

    Click and drag over the data to highlight it. The data that's blue will be the data included in the pie chart.

  3. 3

    Click on the "Insert" tab and then click on the down arrow on the "Charts" panel.

  4. 4

    Press the down arrow under the "Pie" option. Click the first option under "2-D Pie." The pie chart shows beside the data.

Tips and warnings

  • Right-click in the chart area to format the appearance of the pie chart. In this mode, you can add a title to the chart and change the fonts. To display percentages instead of actual values, right-click on the data then click "Format Data Labels." Under "Label Options," place a check beside the "Percentage" option. Uncheck the "Values" option. Click "Close." Grab the borders of the pie chart to resize it and move it around the page.
  • Any change in the data will cause the pie chart to change.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.