How to add a secondary axis in a google doc spreadsheet step 1:.

Google sheets chart secondary axis. On your computer, open a spreadsheet in google sheets. Make sure the secondary axis check box next to the dropdown is selected as well. From the chart editor sidebar, select the type of chart you want to use.

For a discrete axis, set the data column. Change apply series to whichever data series you want to move to the second axis. A recent update to google spreadsheets has added a new feature for former excel users who are looking to get additional functionality.

Select design > change chart type. Change axis to right axis. 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.

On the chart created, click the 3 circles spot on the top right of the chart. To delete a secondary axis, click on it. In line, area, bar, column and candlestick charts (and combo charts containing only such series), you can control the type of the major axis:

Under series where it says, apply to all series, change this to the series you want on the secondary. Then click move to own sheet. Now you can go back.

Ask question asked 10 years, 1 month ago. Then the pie chart will be on its own tab in the google sheet. Google charts secondary axis line charts.