How to Add a Second YAxis to a Chart in Google Spreadsheets

A recent update to Google Spreadsheets has added a new feature for former Excel users who are looking to get additional functionality. If you have two sets of data, and you'd like to use a chart, a second Y-Axis can represent your data on two different scales at the same time.

Check out this quick video to learn how you can add a second Y-Axis to effectively present your data with Google Spreadsheets.

To watch the updated video and read the full article on the BetterCloud Monitor, visit:

[beninua]

WOW - Thanx! That was EXACTLY what I needed to present a series of values in two different currencies that have very different values (US Dollar vs Danish Kroner), and the USD just became a very flat curve along the bottom of the grid. Thank you SO much! This is brilliant! I've subscribed to your channel immediately as I have a feeling this won't be the last time I consult it.

[GoogleGooru]

A recent update to Google Spreadsheets has added a new feature for former Excel users who are looking to get additional functionality.

If you have two sets of data, and you’d like to use a chart, a second Y-Axis can represent your data on two different scales at the same time.

[seangremminger]

I do a project with students that utilizes a secondary Y axis.  This is exactly what I was looking for after not being able to use Excel anymore.

[LucienGuichard]

Excellent!!! I nearly went mad trying to find out how to activate the secondary axis. Now I saw it - FIRST tell Chart that a specific series uses the right axis and THEN select the axis for formatting

[mateuris]

Excellent video, short and to the point. Many thanks!

[davebrown]

awesome, really clear & helped me do what I needed in less than a minute :)

[suhasdara]

It is said that you can't have a right axis when plotting a scatter plot

[dreaddy_bear]

for me the data series section is missing in settings. any ideas?

[booycotest]

This is very outdated. It does not look anything like this anymore