How to sort bar chart in descending order?

Excel Tip - Sort bar chart

Sound like a silly question, but it is a bit confusing indeed.

One day, a friend asked me how to sort a bar chart in descending order.  I told her to sort the data.

She replied: “I did.  The data is sorted in descending order.”

Then I added: “Sort it in reverse order, i.e. ascending order”.

Excel Tip - Sort bar chart

As simple as this.  Yeah!

I know it sounds a bit confusing, but when we know that the data is plotted  from the bottom of the bar chart, then it makes sense.

Excel Tip - Sort bar chart1

What if I want the data table to be displayed side by side and have the bars sorted in the same order?

Excel Tip - Sort bar chart2

No problem.

  1. Select the axis, Right Click
  2. On the Format Axis pane, select Axis Options
  3. Check the Categories in reverse order

Excel Tip - Sort bar chart3

Done! 🙂


About MF

An Excel nerd who just transition into a role related to data analytics at current company......😊 Recently in love with Power Query and Power BI.😍 Keep learning new Excel and Power BI stuffs and be amazed by all the new discoveries.
This entry was posted in Chart and tagged , . Bookmark the permalink.

Comments, suggestions, corrections are welcome.

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.