How to Create Percentage Charts in Excel

Written by lara webster | 13/05/2017
How to Create Percentage Charts in Excel
Some Excel percentage pie charts styles are 3-D. (pie chart 168 image by chrisharvey from

Perhaps one of the only entertaining aspects of tracking and presenting data is creating interesting charts and graphs. Representing data on a chart not only makes the information more visually appealing, but also easier to understand. Use Microsoft Excel to represent data in a variety of ways, including percentage pie charts. Change data from a standard spreadsheet into a colourful pie chart in just a few steps.

Enter the name of your graph in the A1 cell of an empty Excel spreadsheet. For example, if you want to create a graph that represents the most popular sports in your neighbourhood, you might enter something like "Popular Sports on Main Street" in the A1 cell.

Fill out the rest of the data starting in the A2 cell. Enter the type of data to be represented--in the above example, the names of various sports--vertically in the A column.

Enter the corresponding percentages for each item, such as the popularity of each neighbourhood sport, in the B column. For example, if 22 per cent of people prefer basketball, the word "basketball" would appear in the A2 cell and 22 per cent would appear in the B2 cell.

Highlight all of the data to be included in the graph and go to the "Insert" tab on the top of your Excel screen.

Select the "Pie" chart type from the list; choose between several 2-D or 3-D charts.

Click on the first picture under "Chart Layouts" that depicts a chart with percentage signs. Change the name of the title by clicking on it once and entering the new text.

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