How to Move the Vertical Axis to Right Side in Google Sheets Chart

Tip to move the Y-Axis to the right side in Google Sheets Chart. A simple tip that can make your Chart stand out from the rest.

Needless to say the importance of data visualization in reporting. So this time let’s play around with Google Sheets Chart.

As you may know, in Google Sheets, the vertical axis (y-axis) is by default placed on the left side of the chart. It’s common in other spreadsheet applications too. But if you want, you can move the Vertical Axis to Right Side in Google Sheets Chart. How?

As an example, I am creating a line chart and then I will show you how to move the Y-Axis to the right side in Google Sheets Chart.

To plot a chart I am importing some data from the Wikipedia using IMPORTHTML function in Google Sheets.

You can use this formula in cell A1 in a blank Google Sheet and that will populate the essential and proper data for your line chart.

=importhtml("https://en.wikipedia.org/wiki/Foreign_trade_of_India","table",3)

At present, the populated data shows the status of India’s foreign trade (export) from 1999 to 2017.

The first column contains the status year from 1999 to 2017 and the second column contains the worth of commodities in billion (USD) that in year wise.

Just select these two columns and go to Insert > Chart. Google Sheets will insert the below line chart instantly.

line chart showing India's foreign export from 1999 to 2017

I am not going to much detail about chart visualization and customization as our prime concern is to learn how to move the vertical axis to the right side in Google Sheets Chart.

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

We have already the chart in hand. Now to move the Y-axis to the right side, do as follows.

1. Double click on the just-created chart to open the Chart Editor.

2. On the Chart Editor go to the customization tab.

3. Under Series select Right axis.

move y-axis to right side in google sheets

That’s it. This way you can move the Y-Axis to the right side in Google Sheets Chart.

Does the right axis support all chart types?

Nope! Popular chart types like Combo, Area, Column, and line chart supports this feature. You can check the compatibility by going to the customization tab as above.

You May Also Like:

1. Create a Gantt Chart Using Wrike Online Project Management Software.

2. How to Get Dynamic Range in Charts in Google Sheets.

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.

Lookup Previous Values Dynamically in Excel and Google Sheets

Sometimes, you may want to look up the previous values relative to the current...

Sort Data but Keep Blank Rows in Excel and Google Sheets

Using a dynamic array formula or the FILTER command, we can sort data and...

Lookup Values Under Categories in Excel and Google Sheets

We can use a combination of XLOOKUP and VLOOKUP in both Excel and Google...

Extract Items Under a Category from the Same Column in Excel

In Excel, you can use a combination of the XLOOKUP and DROP functions to...

More like this

XMATCH Row by Row: Finding Values Across a Range in Google Sheets

Using the BYROW function with XMATCH in Google Sheets allows us to match values...

Limit Formula Expansion to a Specific Row in Google Sheets

In this tutorial, I’ll explain how to limit the expansion of an array formula...

3-D Referencing Structured Data Tables in Google Sheets

When you have several tables within a single sheet—not across multiple sheets in a...

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.