How to Make a Ranking Chart in Microsoft PowerPoint

Written by james t wood Google
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Make a Ranking Chart in Microsoft PowerPoint
Charts and graphs communicate data,. (IT Stock/Polka Dot/Getty Images)

Whether you want to show the comparative bitterness of different beers, the cost of ethically sourced diamonds or the powers of super heroes, a ranking list can help. Because PowerPoint uses the Excel component of Microsoft Office to format the data for charts and graphs, the sorting feature in Excel will make ranking the items in your chart a snap. You can create and edit the spreadsheet data all from within PowerPoint and the information will save with the PowerPoint presentation so your rankings for NASCAR drivers can be e-mailed across the world.

Skill level:
Moderately Easy


  1. 1

    Open your PowerPoint presentation and click on the slide where you want to insert the ranking chart. Click the "Insert" tab and then click "Chart." Choose the "Clustered Bar Chart" from the "Bar Chart" section and then click "OK."

  2. 2

    Enter the data for your chart in the Excel spreadsheet that pops up. The standard chart has three series of data, but you can change the information to suit your own ranking chart. Enter more rows of data to show more entries; enter more columns of data to show more values by which things are ranked. Drag the blue border to include the data you want in your ranking chart.

  3. 3

    Click the top cell with data in the column you want to use as your ranking criteria. Click the "Sort and Filter" button in the "Editing" section on the right side of the "Home" tab. Choose "Smallest to Largest." The entries are now reordered by that sorting in the Excel spreadsheet and in the PowerPoint graph.

Tips and warnings

  • Don't delete columns from the spreadsheet as it will cause an error. If you don't want one of the columns to show in the ranking chart, click the title for that column in the PowerPoint graph and press "Delete."

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.