If you have two sets of data, and.
Add second y axis google sheets. With the data range for the chart being from the row with the date. Click on format selection in current section to open format data series dialog. An additional axis will hence be added on the right side of your chart.
You can see when creating the graph in google sheets, it shows up the same way as it does. Add second axis google sheets. Hither is how this is done:
You can also follow the easy step below to add a second. But we need to show “ profit margin ” data series on the secondary axis. At the right, click customize.
In the sheet views window that opens, select “y. An update to google sheets has added a new feature for former excel users who are looking to get additional functionality. Now you can go back.
The chart editor sidebar will appear. On your computer, open a spreadsheet in google sheets. How to add secondary axis in excel and google sheets excelchat from.
Learn in this google sheets tutorial 2019sections0:00 1.how to add a secondar. Change apply series to whichever data series you want to move to the second axis. On your computer, open a spreadsheet in google sheets.