Click the line graph and bar graph icon.

Google sheets add second y axis. Under axis, choose right axis. Choose the right axis under the axis option. How to add secondary axis in excel and google sheets excelchat from.

Now you can go back. Change apply series to whichever data series you want to move to the second axis. Add a secondary y axis.

Click on format selection in current section to open format data series dialog. 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. On your computer, open a spreadsheet in google sheets.

An additional axis will hence be added on the right side of your chart. How do i add a second y axis in google sheets? Add a secondary y axis both data sets display on the same axis, at the same scale.

Learn in this google sheets tutorial 2019sections0:00 1.how to add a secondar. But we need to show “ profit margin ” data series on the secondary axis. On the chart editor on the right paw side, select the customize.

On your computer, open a spreadsheet in google sheets. Then with the settings apply to one of the series,. Create a spreadsheet with the data you want to graph.