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
Other People Are Reading
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."
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.
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."
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for