DISCOVER
×

How to Make a Percentage Pie Chart With Excel

Updated April 17, 2017

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'll Need

  • Microsoft Excel 2007 or later
Cite this Article A tool to create a citation to reference this article Cite this Article

About the Author

Meg North has written professionally since 2008 as an online copywriter for the Sturbridge Yankee Workshop. She also published a short story in "The Maine Scholar." North has a Bachelor of Arts in media writing from the University of Southern Maine.