How to create a chart in ranking order in Excel?
While we insert a chart to show the data more visually, the data in the chart will be placed in the order as in the data range. But do you know how to create a chart in a ranking order as below screenshot shown in Excel? Here, I will tell you the method.
Recommended Excel Productivity Tools
To create a chart in a ranking order, you just need to sort the original data first, then create a chart of the data.
1. Select the data you use to create a chart, and click Data > Sort. See screenshot:
2. In the Sort dialog, specify the column you want to sort by, the criteria you want to sort on, and the order you want. See screenshot:
3. Click OK. The data has been sorted by smallest to largest.
4. Then click Insert > Insert Column or Bar Chart and select a chart as you need.
Then the ranking chart has been created.
You maybe interested in this utility:
Convert Number to Ordinal
|Kutools for Excel's Convert Number to Ordianl to quikcly convert cardinal numbers to ordinal numbers.|
|To Get Free Trial Now!|