How to Switch X and Y Axis in Google Sheets

In this tutorial, you will learn how to switch X and Y axis in Google Sheets.

How to Switch X and Y Axis in Google Sheets

When you make a chart with Google Sheets, you’ll see that the program tries to comprehend the data you’ve chosen and automatically selects a column for each of your x and y axes. The axes it chooses, meanwhile, might not necessarily be what you desire.

Once you are ready, we can jump right into learning how to switch X and Y axis in Google Sheets.

Switch X and Y Axis in Google Sheets

Before we begin we will need a group of data to be used to create a scatter chart.

Step 1

Make sure your group of data is displayed in a clean and tidy manner. This will help us to create the scatter chart easily.

Untitled

Step 2

Select the entire data cell, choose Insert, and select Chart.

Untitled

Step 3

By default, Google Sheet will generate a scatter chart.

Step 4

To switch the positions of X and Y axis, you will need to double-click on the graph to access the chart editor. Now, click the Setup tab, to switch X-axis to Height instead of Weight, click and choose Height. Then do the same for Y-axis as well.

Untitled

Step 5

Once you are done editing and customizing the scatter chart, it will look like this.

Untitled

Summary

That’s all there is to it. You are welcome to copy the example spreadsheet below to see how it is done. The most crucial lesson is to enjoy yourself while doing it.

Example Spreadsheet: Make a copy of the example spreadsheet

In this tutorial, I covered how to switch X and Y axis in google sheets. Want more? Check out all the Google Sheets Tutorials.