Choose the right axis under the axis option.

How to add a secondary axis in google sheets. A secondary axis has been. In this chart, the primary vertical axis. You need to apply a right axis to one of the series.

With the data range for the chart being from the row with the date. Check out this quick video to. 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. By default, google sheets typically only generates one y axis for a chart, but you can easily add. 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.

So, we add a secondary axis to the mix and make the chart better (as shown below). Change axis to right axis. Both data sets display on the same axis, at the same scale.

Add a secondary y axis. Then with the settings apply to one of the. Under series where it says, apply to all series, change this to the series you want on the secondary.

The chart editor sidebar will appear. You can also follow the easy step below to add a second. 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.