In order to set one of the data columns to display on the right axis, go to the.

How to add a secondary axis in google sheets. You need to apply a right axis to one of the series. Choose the right axis under the axis option. 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.

By default, google sheets typically only generates one y axis for a chart, but you can easily add. You can also follow the easy step below to add a second. One on the left sid.

Add a secondary y axis. Make sure the secondary axis check box next to the dropdown is selected as well. How to add a secondary axis in a google doc spreadsheet.

The chart editor sidebar will appear. Under series where it says, apply to all series, change this to the series you want on the secondary. Change axis to right axis.

Then with the settings apply to one of the. Change apply series to whichever data series you want to move to the second axis. On your computer, open a spreadsheet in google sheets.

An additional axis will hence be added on the right side of your chart. With the data range for the chart being from the row with the date. Check out this quick video to.