How to Make a Percentage Pie Chart With Excel

Written by meg north
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Make a Percentage Pie Chart With Excel
Pie charts show the percentage of each category as part of the whole. (Hemera Technologies/AbleStock.com/Getty Images)

Microsoft Excel 2007 has the ability to calculate pie chart percentages based on the data values you input into a spreadsheet. You can create a pie chart based on any group of data in an Excel spreadsheet, and you can also customise the pie chart with data labels and a two-dimensional or a three-dimensional appearance. Other types of charts to create from Excel spreadsheet data include column charts, bar charts and line charts.

Skill level:
Moderate

Other People Are Reading

Things you need

  • Microsoft Excel 2007 or later

Show MoreHide

Instructions

  1. 1

    Click "Start" and click "All Programs". Click the "Microsoft Office" folder and click "Microsoft Excel" to open the program.

  2. 2

    Create a two-columned spreadsheet with the pie chart data. Type the data names in column "A". Type the data percentage values in column "B". Click "Save" and save the spreadsheet.

  3. 3

    Click in the first cell under column "A" and drag the mouse until all of the cells with the data are selected. Click the "Insert" tab. Click "Pie" in the "Charts" group. Click the style of pie chart you want.

  4. 4

    Hover your mouse over the main pie chart area and right-click. Click "Add Data Labels" from the drop-down menu. Right-click again and this time select "Format Data Series" from the drop-down menu.

  5. 5

    Check the box next to "Percentage" under "Label Contains" in the "Format Data Labels" dialogue box. Click "Close". The percentages appear on the pie chart.

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.