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.

Create a chart in ranking order

---

Create a chart in ranking order

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.