It is possible to flip the X and Y axes on certain charts. For our example, we have the following data and the resulting chart:
We have switched the x and y axes in the data, which explains why we have the following chart. How can we switch the axes back to get the correct graph?
How to flip X and Y axes of the chart
In order to do this technique, we assume that you have added a header row to your data. Here are the steps:
Step 1: Double-click the chart. The Chart editor sidebar will appear. Click the Setup tab. The labels X-axis and Series should appear.
Step 2: As you can see, Google Sheets automatically used the header rows as the names of the X-axis and Series. Underneath these labels are the options for selecting the X-axis (by its name, for x-axis) and the Series (for the y-axis). Click the shaded box below X-axis. Options will appear. Select the right option. For our case, “real x” should be the header for the X-axis.
Step 3: Do the same for the Series or the y-axis. For our case, “real y” should be in the Series.
Then you are done! Here is the original chart:
The final chart:
As you can see, the values are now swapped to their right places. There is no need to modify the source sheet, so you can do it even if you cannot edit the source sheets!
Related Articles
-Add Title and Label Legend Google Sheets Chart
-Line of Best Fit Google Sheets
-Finding the Slope in Google Sheets
-Create a chart with Multiple Ranges of Data
Recommended articles
More resources
