By default, google sheets typically only generates one y axis for a chart, but you can easily add.

How to add a secondary axis in google sheets. Under series where it says, apply to all series, change this to the series you want on the secondary. In order to set one of the data columns to display on the right axis, go to the. With the data range for the chart being from the row with the date.

Make sure the secondary axis check box next to the dropdown is selected as well. You need to apply a right axis to one of the series. 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.

Both data sets display on the same axis, at the same scale. Check out this quick video to. Then with the settings apply to one of the.

So, we add a secondary axis to the mix and make the chart better (as shown below). An additional axis will hence be added on the right side of your chart. Change apply series to whichever data series you want to move to the second axis.

On your computer, open a spreadsheet in google sheets. Add a secondary y axis. You can also follow the easy step below to add a second.

How to add a secondary axis in a google doc spreadsheet. The chart editor sidebar will appear. A secondary axis has been.