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.
Make sure your group of data is displayed in a clean and tidy manner. This will help us to create the scatter chart easily.
Select the entire data cell, choose Insert, and select Chart.
By default, Google Sheet will generate a scatter chart.
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.
Once you are done editing and customizing the scatter chart, it will look like this.
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.