In order to set one of the data columns to display on the right axis, go to the customize.
How to add second y axis in google sheets. Then, on the excel spreadsheet's top menu bar, select chart design. Add a secondary y axis both data sets display on the same axis, at the same scale. One on the left sid.
Go to design > change chart type. Under series where it says, apply to all series, change this to the series you want on the secondary. A chart editor dialogue box is opened.
If you have two sets of data, and. On your computer, open a spreadsheet in google sheets. Then with the settings apply to one of the series,.
You need to apply a right axis to one of the series. Choose secondary axis for the data series “profit margin”. Step 1 select the range you want to chart, including headers:
Step 3 a new chart will be inserted and can be edited as. 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. Customizing the two y axes chart steps to be followed:
From the box, click the customize tab. On the chart drawn, double click. Check out this quick video to.