How to Move the Y-Axis to the Right in Google Sheets

Needless to say, data visualization is crucial in reporting. This time, let’s play around with Google Sheets charts. Here’s how to move the Y-axis to the right side in Google Sheets charts—a simple tip that can make your chart stand out from the rest.

As you may know, in Google Sheets, the vertical axis (Y-axis) is placed on the left side of the chart by default. This is common in most spreadsheet applications. However, if you want, you can move the vertical axis to the right side in Google Sheets. How?

Let me show you. As an example, I’ll create a line chart and demonstrate how to move the Y-axis to the right side.

To plot the chart, I’m using the following sample data in A1:B20, which shows India’s foreign trade (exports) from 1999 to 2017:

  • The first column contains the years from 1999 to 2017.
  • The second column contains the export values (in billions of USD) for each year.
Sample data table displaying India's foreign trade (exports) values from 1999 to 2017

Just select these two columns, then go to Insert > Chart and choose Line chart under Chart Type. Google Sheets will instantly insert the line chart shown below.

Line chart showing exports versus years

I’m not diving too deep into chart visualization and customization here, as our primary focus is on moving the vertical axis to the right side.

How to Move the Y-Axis to the Right Side in Google Sheets

Now that we have our chart ready, follow these steps to move the Y-axis to the right:

  1. Click on the chart to select it.
  2. Click the three vertical dots in the top-right corner of the chart and select Edit Chart.
  3. In the Chart Editor, go to the Customization tab.
  4. Under the Series section, select Right axis.
GIF demonstrating moving the Y-axis to the right side in a Google Sheets chart

That’s it! Your Y-axis is now on the right side of the chart.

Does the Right Axis Work with All Chart Types?

No, not all chart types support this feature. However, popular chart types like Combo, Area, Column, Bar, and Line charts do. To check compatibility, navigate to the Customization tab in the Chart Editor as explained above.

Resources

Prashanth KV
Prashanth KV
Your Trusted Google Sheets and Excel Guide Prashanth KV brings a wealth of experience in Google Sheets and Excel, cultivated through years of work with multinational corporations in Mumbai and Dubai. As a recognized Google Product Expert in Docs Editors, Prashanth shares his expertise through insightful blogging since 2012. Explore his blog for practical tips and guidance on maximizing your spreadsheet skills.

Cycle Highlights in Google Sheets – Rotate Highlights Daily

Want to cycle highlights in Google Sheets every day? Whether you're rotating a meal...

Filter Rows Containing Multiple Selected Values in Google Sheets

This tutorial explains how to filter rows in a column containing multiple selected drop-down...

Two-Way Lookup with XLOOKUP in Google Sheets

When you need to look up one search key vertically and another horizontally, you...

How to Filter by Total in Google Sheets Pivot Tables

Google Sheets offers many tools to summarize and analyze data, but Pivot Tables are...

More like this

Cycle Highlights in Google Sheets – Rotate Highlights Daily

Want to cycle highlights in Google Sheets every day? Whether you're rotating a meal...

Filter Rows Containing Multiple Selected Values in Google Sheets

This tutorial explains how to filter rows in a column containing multiple selected drop-down...

Two-Way Lookup with XLOOKUP in Google Sheets

When you need to look up one search key vertically and another horizontally, you...

LEAVE A REPLY

Please enter your comment!
Please enter your name here

This site uses Akismet to reduce spam. Learn how your comment data is processed.