Unbelievable Google Sheets Graph With Two Y Axis
On your computer open a spreadsheet in Google Sheets.
Google sheets graph with two y axis. If you look at the chart on the link below there are labels called purple Green Purple Red Yellow White and Black. Create a graph with a left and a right vertical axis in the new 2017 Google Sheets chart editor. Choose the data you want to graph.
Here in this workaround that to show month and year in x-axis in Google Sheets you will see that limitation. Second the variables in both the X-axis and Y-axis are independent. 1 Is it possible to create a dual Y-axis spreadsheet chart using the in-house charting features of google spreadsheet.
If it does not suit you eg. Select the two columns of numbers you want to compare by clicking on and selecting the column names. That is you have to determine a fixed step your axes eg.
Highlight to sets of data you want to chart together. Theyre doubly awesome when you chart two things at once. I hope the below workaround will.
Under Axis choose Right axis. You can add it to a line area or column chart using a combo chart. Add a second Y-axis On your computer open a spreadsheet in Google Sheets.
Active 1 year 11 months ago. You can add a second Y-axis to a line area or column chart. Google Spreadsheet Y-axis Label Editing.