How to Make a Percentage Pie Chart With Excel

Written by meg north | 13/05/2017
How to Make a Percentage Pie Chart With Excel
Pie charts show the percentage of each category as part of the whole. (Hemera Technologies/ 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.

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

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.

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.

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.

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.

Things you need

  • Microsoft Excel 2007 or later

Show MoreHide

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

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