Ask question asked 10 years, 1 month ago.

Google sheets chart secondary axis. In line, area, bar, column and candlestick charts (and combo charts containing only such series), you can control the type of the major axis: On the chart created, click the 3 circles spot on the top right of the chart. Select secondary axis for the data series you want to show.

Then click move to own sheet. This is my first post about google charts, an amazing tool to create simple charts in your html files.it is free and really powerful, with a lot of options and easy to implement. Removing the secondary axis is as simple as hitting the delete key (literally).

If you have two sets o. To visualize the data (above) using combo charts, copy and paste it into your google sheets. A recent update to google spreadsheets has added a new feature for former excel users who are looking to get additional functionality.

For a discrete axis, set the data column. The chart will update to the selected chart. From the chart editor sidebar, select the type of chart you want to use.

Now you can go back. How to add a secondary axis in a google doc spreadsheet step 1:. Change axis to right axis.

Viewed 8k times 4 i'm currently learning a bit of google charts with. Make sure the secondary axis check box next to the dropdown is selected as well. Under series where it says, apply to all series, change this to the series you want on the secondary.