How to Reverse Axis Order in Excel Chart

This post will guide you how to reverse the order of a chart Axis in your current worksheet in Excel 2013/2016.

Assuming that you have created a column chart based on your data in your worksheet, and you may want to reverse the Axis order in this chart. How to do it. And his post will show you one method to accomplish the result of reversing Axis order in your chart.

Reverse Axis Order in a Chart


To reverse Axis Order in a chart, you need to create a chart based on your original data firstly, and then do the following steps:

Step1:  right click on one Axis that you want to reverse, such as: X Axis or Y Axis, and then select Format Axis option from the drop down menu list. And the Format Axis pane would be displayed in the left of Excel window.

reverse axis orader1

Step2: check values in reverse order or Categories in reverse order option under the Axis Options section in the Format Axis pane.

reverse axis orader3

Step3: close the Format Axis pane, and you would see that the selected Axis is reversed.

reverse axis orader2

 

 

You might also like:

Comments

So empty here ... leave a comment!

Leave a Reply

Your email address will not be published. Required fields are marked *

Sidebar