Follow the steps below to easily add a secondary axis in Google Sheets,
Open the Google Sheet that contains the data you want to plot. Click and drag to highlight the data for your chart. This includes the data series that will be on both the primary and secondary axis.
With the data highlighted, click on "Insert" in the top menu, then select "Chart" from the dropdown menu.
Google Sheets will automatically generate a chart based on your data.
Click on the three dots icon in the upper right corner of the chart and select “Edit the Chart.” This will open the Chart Editor on the right side of the screen. Here, you can customize your chart.
In the Chart Editor, under the "Setup" tab, ensure your chart type supports dual axes, such as "Line chart" or "Combo chart." Select the appropriate type for your data.
Still in the Chart Editor, switch to the "Customize" tab. Scroll down to find the "Series" section.
Here, select the data series you want on the secondary axis.
Then, click the dropdown under “Axis” and select “Right Axis.”
Under the "Customize" tab, you can now adjust settings for both axes. This includes the axis title, format, and scale. Make sure to adjust both the primary and secondary axis to clearly represent your data.
Review your chart to ensure it accurately represents your data with both the primary and secondary axes. You can make any additional adjustments in the Chart Editor as needed.
We hope that you now have a better understanding of how to add a secondary axis in Google Sheets. If you enjoyed this article, you might also like our article on PMT function in Google Sheets or our article on how to find correlation coefficients in Google Sheets.
