Choose the right axis under the axis option an additional axis will hence be added on the right side of your chart.

How to add 2 y axis in google sheets. Then with the settings apply to one of the series,. Then click the insert tab along the top. Add a secondary y axis both data sets display on the same axis, at the same scale.

To create an xy bar in google sheets, follow these steps: Create plot next, highlight the cells in the range a2:b16. Open your spreadsheet and click on the “sheets” menu.

Insert a chart or graph in google sheets. Choose secondary axis for the. In order to set one of the data columns to display on the right axis, go to the customize.

In the next column, enter the. The chart editor sidebar will appear. You’ll see multiple options, such as.

Enter the dataset that you want to make the axes. Enter the data first, let’s enter a simple dataset into google sheets: Adding a secondary axis double click on graph click on customize click on series 4.

(optional) change chart type to line. Click on the “build a form”. 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.