DISCOVER
×

How to Create Percentage Charts in Excel

Updated March 23, 2017

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.

Cite this Article A tool to create a citation to reference this article Cite this Article

About the Author

Lara Webster has been writing professionally since 2009. Her work has been featured on Relationships in the Raw, The Nursery Book, Spark Trust and several travel-related websites. Webster holds a Bachelor of Arts in English and a Master of Arts in mass communication and media studies, both from San Diego State University.