How to Create Percentage Charts in Excel

Written by lara webster
  • Share
  • Tweet
  • Share
  • Pin
  • Email
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.

Skill level:


  1. 1

    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.

  2. 2

    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.

  3. 3

    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.

  4. 4

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

  5. 5

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

  6. 6

    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.

Don't Miss

  • 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.