In this tutorial, you will learn how to add a second y-axis in Google Sheets.
How to Add a Second Y-Axis in Google Sheets
On the Cartesian coordinate plane, the y-axis is the vertical axis. The y-axis begins at a negative value and rises to a positive value. The y-axis also serves as the starting point, or 0 points, for determining how far a point on a graph extends horizontally. In experiments, the dependent variable is plotted on the y-axis, which is also known as the “effect” of the independent variable, which is plotted on the x-axis.
A second y-axis can show your data on two separate scales at the same time if you have two sets of data and want to use a chart.
Once you are ready, we can get started by using real-life scenarios to help you understand how to add a second y-axis in Google Sheets.
Adding a Second Y-Axis in a Chart
Before we begin we will need a group of data to be used to create the chart.
Make sure your group of data is displayed in a clean and tidy manner. This will help us to create the chart easily.
Select the entire data cell, choose Insert, and select Chart.
By default, Google Sheet will use the selected group of data to generate a pie chart. Simply change the chart to a combo chart in the Chart Editor.
Now, you can customize the chart to your preference. We will change the chart title to ‘Sales’ for a better representation of the chart. Also, to emphasize the chart title, we will change the text color to black, bold it, and also align it to the center.
To add a second y-axis, go to the Chart Editor, select Series, select Units Sold, and select Right Axis under the Axis box.
Once you are done editing and customizing the chart, it will look something like this.
That’s all there is to it. You are welcome to copy the example spreadsheet below to see how it is done. The most crucial lesson is to enjoy yourself while doing it.
Example Spreadsheet: Make a copy of the example spreadsheet
In this tutorial, I covered how to make categories in google sheets. Want more? Check out all the Google Sheets Tutorials.