# How to Switch (Flip) X & Y Axis in Excel & Google Sheets

Written by

Reviewed by

*This tutorial will demonstrate how to flip the X and Y Axis in Excel & Google Sheets charts.*

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

**X & Y Axis Explanation**

- X Axis – horizontal line of the graph. Recommended dependent variable
- Y Axis – vertical line of the graph; Recommended independent variable

**Starting with Your Base Graph**

In this explanation, we’re going to use a scatterplot as the example to switch the X and Y axes. This scatterplot below shows the how the clicks and sales are related. Let’s say we want to change this graph so that the Sales will be on the Y Axis and Clicks on the X Axis.

**Switching your X and Y Axis**

**Right Click on Your Graph > Select Data**

** **

2.** Click on Edit**

3. ** Switch the X and Y Axis**

You’ll see the below table showing the current Series for the X Values and current Series for the Y Values.

You want to swap these values. The formula for “Series X Values” should be in the “Services Y Values” and vice versa as seen below. Then click OK. In order to swap, use:

**Ctrl + C** to Copy

**Ctrl + V** to paste

After clicking OK, you’ll see that the values of the X and Y Axis has swapped as requested. However, as you can see, we still must switch the Axis Title Names as these have not updated.

4. **Updating Axis Titles**

Double click on the Axis Title and change the name to the appropriate title that represents the values on that axis.

**Final Graph after Swap**

The final result shows the visualization in a more pleasing way where Sales are on the Y axis and Clicks are on the X Axis.

**How to Switch (Flip) X and Y Axis in Google Sheets**

**Switching X and Y Axis**

**Right Click on Graph > Select Data Range**

2. Click on Values under X-Axis and change. In this case, we’re switching the X-Axis “Clicks” to “Sales”.

Do the same for the Y Axis where it says “Series”

**Change Axis** **Titles**

Similar to Excel, double-click the axis title to change the titles of the updated axes.

**Final Graph after Swap**

Finally, we have a finished product after swapping the x and y axis as shown below.