How to☝️ Have 2 Y-Axes (Right-Side) in a Chart in Google Sheets

If you’ve ever come across a chart with two y-axes in Google Sheets and wondered how to do it, you’re in the right place. This article will guide you through the step-by-step process of customizing your chart with two y-axes.

Prepare Your Data

Before creating your chart, start by preparing your data. Any numeric dataset will work, but for a chart with a secondary y-axis, make sure the variables or dimensions to be plotted on both axes are measured in different scales. For example, if you have a dataset with the number of steps taken each day and the corresponding number of calories burned, ensure that the values are measured in different units.

Insert a Chart

After preparing your data, it’s time to insert a chart. Follow these simple steps:

1. Click on the Insert menu.
2. Select Chart from the drop-down options.

3. In the Chart editor, go to the Data range section and select the range containing the data you want to visualize.
4. Click OK to lock in the selected ranges.

You should now have a chart in your spreadsheet.

Add a Secondary Y-Axis

Now that you have a chart, you may notice that the bars representing the second variable appear much smaller compared to the bars of the first variable. To properly visualize the second variable, you can add a secondary y-axis.

Follow these steps to add a secondary y-axis:

1. In the Chart editor window, click on the Customize tab.
2. Select the Series option.
3. Click on Apply to all series and select the second variable.
4. Go to the Axis section and choose the Right axis option.

The second y-axis will now appear on the right side of the chart, representing the measures of the second variable. You can adjust the axis scale to change how the data is displayed.

Customize Label Text

To make the data on the chart easily comprehensible, you can customize the label colors for each axis. This way, each axis will match the color of the variables they measure.

Here’s how you can customize the label text:

1. In the Customize tab of the Chart editor window, click on the Right vertical axis section.
2. Select the desired color for the labels.

You can also change the colors for the labels on the left axis by making a similar change from the Vertical axis section.

With the labels in the right colors, it’s easier to interpret the data on the chart.

Conclusion

Creating a chart with two y-axes in Google Sheets is a straightforward process. Before creating the chart, make sure the data is appropriate for the chart and customize the settings to make it easily understandable. Now you can create visually appealing charts that present multiple variables with clarity.

To learn more about other helpful tips and tricks for Google Sheets, check out Mr Reviews at mate40prouserguide.com.