How to Switch X and Y Axis in Excel
(Flip Chart Axes)

Most graphs and charts in Excel, except for pie charts, has an x and y axes where data in a column or row are plotted.

Here’s an example of an Excel line chart that shows the X and Y axes:

The x-axis is the horizontal line where the months are named. The y-axis is the vertical line with the numbers.

There are times when you have to arrange the variables in the spreadsheet before making a chart out of them.

Like in the case of making a scatter chart. It’s recommended that the independent variable should be on the left while the dependent variable should be on the right.

But of course, that’s not general knowledge. So chances are, some people would have swapped them.

In this tutorial, we’ll borrow this data set from the scatter plot tutorial where the values in the left (B) and right column (C) isn’t the recommended arrangement.

The chart still works. However, the “Pageviews” value series should be on the y-axis (horizontal line) while the “Sales” value series should be on the x-axis (vertical line).

If you don’t know how to switch the axes, you would’ve deleted the chart and copy-pasted the contents of columns B and C to exchange the values.

There’s a better way than that where you don’t need to change any values.

First, right-click on either of the axes in the chart and click ‘Select Data’ from the options.

A new window will open.

Click ‘Edit’.

Another window will open where you can exchange the values on both axes.

What you have to do is exchange the content of the ‘Series X values’ and ‘Series Y values’.

Your goal is to change the values from this:

To this:

Once you do that, the value series on the axes would be swapped.

Notice that we didn’t change any values on the spreadsheet data at all. All we did was customized the chart.

You just learned how to switch x and y axis in Excel in a few minutes.

Microsoft Excel’s charts are so advanced that you can swap the horizontal axis values with the vertical axis values without touching the original data on the spreadsheet.

Pretty cool, right?😎

Now, charts are only useful if you have numbers to show. And those numbers are typically derived from some sort of calculation.

The best functions for calculations or helping with calculations are SUMIF, IF, and VLOOKUP.

If you want to learn those, please enroll in my free 30-minute online Excel course here. We’ll send it directly to your inbox📩

While you’re learning about charts you might want to check out my huuuuge guide to all Excel charts (and how to use them).