Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.

How to invert axis in Excel – Excelchat

There are times when we just have to flip axes in Excel to get the correct order of the data we are working with. Cases such as a bar chart compared with data, we have the axis order reversed in the default mode. This requires us to know how to reverse the axis in order to work with it. In this post, we shall learn how to flip axis.

Step-by-step guide on inverting axis

To have a quick view of how to arrange categories in inverse order, let us look at a step-by-step guide on how to do it;

Flipping axis using the Format Axis dialog

Step 1: Select Format Axis

The first thing we have to flip x and y axis is to select the Format Axis button. To do this, we have to right click the y axis that we want to reverse. Then, select the Format Axis from the context menu.

Step 2: Check Categories in reverse order

The next thing to do is to check the Categories in reverse order. This is found in the Format Axis dialog, in the Axis Options.

Step 3: Close the dialog box

To have the axis flipped, you now need to close the dialog box. This will automatically flip the axes.

Note that with this process, you can be able to reverse the order of categories in any way you want. When you know how to reverse axes is essential, as it can help you be able to flip chart.

Instant Connection to an Excel Expert

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

Leave a Comment

avatar

Subscribe to Excelchat.co

Get updates on helpful Excel topics

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc