How to Re-order X Axis in a Chart

to Reverse X Axisto Sort Alphabetical Order

1. To reverse X Axis:

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

This image has an empty alt attribute; its file name is excelreverseaxisorder01.jpg

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

This image has an empty alt attribute; its file name is excelreverseaxisorder02.jpg

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".

This image has an empty alt attribute; its file name is excelreverseaxisorder04.jpg

2. To Sort Alphabetical Order:

Step 1: To sort X Axis alphabetically, the quick way is to sort the table. For example, to make a column chart with the table below.

Step 2: Sort data table alphabetically from Z to A, the X-Axis is also sorted.

Download Example

6 Comments

  1. Windy March 18, 2019
  2. Becky Grunow April 20, 2020
    • David May 23, 2020
  3. Luke May 23, 2020
    • David May 23, 2020
  4. Junick July 24, 2020

Leave a Reply