On your computer, open a spreadsheet in google sheets.

Add secondary axis google sheets. An additional axis will hence be added on the right side of your chart. Make sure the secondary axis check box next to the dropdown is selected as well. You can also follow the easy step below to add a second.

With the data range for the chart being from the row with the date. Datasets with multiple variables can be hard to interpret using standard graphs and charts with a single y axis, but in many cases adding a second y axis to label the data can be very helpful. You need to apply a right axis to one of the series.

Then with the settings apply to one of the. How to add a secondary axis in a google doc spreadsheet. Both data sets display on the same axis, at the same scale.

A secondary axis can also be used as part of a combination chart when you have mixed types of data (for example, price and volume) in the same chart. Change apply series to whichever data series you want to move to the second axis. In this chart, the primary vertical axis.

In order to set one of the data columns to display on the right axis, go to the customize tab. By default, google sheets typically only generates one y axis for a chart, but you can easily add. Change axis to right axis.

Check out this quick video to. Choose the right axis under the axis option. Add a secondary y axis.