What you need to do is a few steps:

How to add 2 y axis in google sheets. The chart editor sidebar will appear. How to add a second y axis in google sheet charts Check out this quick video to.

To create an xy bar in google sheets, follow these steps: In order to set one of the data columns to display on the right axis, go to the customize. You’ll see multiple options, such as.

Create plot next, highlight the cells in the range a2:b16. One on the left sid. Click on the “build a form”.

(optional) change chart type to line. To change the font of the title, click the font styles button. Under series where it says, apply to all series, change this to the series you want on the secondary.

If you don’t already have a chart in your spreadsheet, you’ll have to insert one in order to add axis labels to it. Choose the right axis under the axis option an additional axis will hence be added on the right side of your chart. Add a secondary y axis both data sets display on the same axis, at the same scale.

Insert to chart then add your data series, as you normally would with a single axis chart. Adding a secondary axis double click on graph click on customize click on series 4. You need to apply a right axis to one of the series.