In line, area, bar, column and candlestick charts (and combo charts containing only such series), you can control the type of the major axis:

Google sheets secondary axis. One on the left sid. How to add a secondary axis in a google doc spreadsheet step 1:. Now you can go back.

Change axis to right axis. You can see when creating the. Scroll to the bottom of the series section and ensure left axis is selected in the axis dropdown.

In this chart, the primary vertical axis. Check out this quick video to. On your computer, open a spreadsheet in google sheets.

With the data range for the chart being from the row with the date. How to add secondary axis in excel and google sheets. Both data sets display on the same axis, at the same scale.

If you have two sets o. You need to apply a right axis to one of the series. To visualize the data (above) using combo charts, copy and paste it into your google sheets.

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. Add a secondary y axis. Change apply series to whichever data series you want to move to the second axis.