How to Reverse Axis Order in a Chart

Sometimes you may need to reverse the Axis order in a chart, please see below for details. In this example, we use bar chart as the example, but it is the same procedures when you work with other type of charts. 

1. To reverse X Axis:

Step 1: Right-click on the X Axis, and click "Format Axis" in the dialog box;

Step 2: In the "Format Axis" window, check the box "Categories in reverse order".

Step 3: You will find the X-Axis is now reversed. At the same, the Y-Axis also moved to the right side;

Step 4: To move the Y Axis back to the left, right-click the Y Axis, and change the Label Position from "High" to "Low" in the "Format Axis".

2. To reverse Y Axis:

Step 1: Right-click Y-Axis, then click "Format Axis". In the "Format Axis" window, check the box in front of "Values in reverse order". This will reverse the order of the Y-Axis;

Step 2: The X-Axis will also move from bottom to top, to move X Axis back to the bottom, please right click X-Axis, then in the "Format Axis" window, change the Label Position from "Low" to "High".

Download Example

One Response

  1. ChartHelpPlease August 19, 2020

Leave a Reply