You need to apply a right axis to one of the series.

How to add second y axis in google sheets. In order to set one of the data columns to display on the right axis, go to the customize. For example, you can put in a1 =sequence (rows (a:a),1,0,1) and you will get a column with indexes starting at zero. A chart editor dialogue box is opened.

Step 2 open the insert menu, and select the chart option: Each data point should be contained in an individual cell with rows and columns that are labeled. From the box, click the customize tab.

One on the left sid. If you have two sets of data, and. Choose the right axis under the axis option an additional axis will hence be added on the right side of your chart.

Check out this quick video to learn how you can add a. Choose secondary axis for the data series “profit margin”. Add a secondary y axis both data sets display on the same axis, at the same scale.

Customizing the two y axes chart steps to be followed: Step 1 select the range you want to chart, including headers: Under series where it says, apply to all series, change this to the series you want on the secondary.

You can use the column a as a column for index marks. How to add a second y axis in google sheet charts Step 3 a new chart will be inserted and can be edited as.