Google Sheets Charts with 2 Y-Axes

Google Sheets allows you to create graphs and charts of your data to include in your spreadsheets or to export for use elsewhere.

Take a look at this simple example sheet:

Click image to enlarge

Click image to enlarge

I’d like to plot both sets of data on the same chart. To do so, I’ll highlight the range containing both the X-axis data and the two sets of Y-axis data:

Click image to enlarge

Click image to enlarge

To fire up the chart editor, I can now use Insert > Chart from the menu:

Click image to enlarge

Click image to enlarge

The chart editor dialog offers the choice of a wide variety of chart types. A few are offered in the Start tab of the editor; if none of these suit your needs, go to the Charts tab where many more are available. I’ve chosen a so-called Combo Chart for this example, which combines a bar and a line chart on the same axes.

Click image to enlarge

Click image to enlarge

Note how the application has made some intelligent guesses over the data and ranges for the axes; with minimum effort I already have a decent-looking chart. However, the line representing Sales is a little squashed by the scale of the Y-axis. I’d like to zoom the Y-axis scale, but only for the Sales data set.

To do that, I turn to the Customise tab, scroll down and select the data set in question from the Series pulldown selector:

Click image to enlarge

Click image to enlarge

Now I can change the Axis setting for this data from its default Left Axis to Right Axis, and immediately the scale of the Sales data becomes much more easily readable:

Click image to enlarge

Click image to enlarge

So far so good. However, the scale of my Enquiries bar chart, now that the sales data has been ignored, has automatically reset to begin at 50 instead of 0. I’d rather view it from a baseline of 0, as before. I can do that.

Returning to the spreadsheet and viewing my chart, I can click on various aspects of the chart to go into a Quick Edit mode. In this case, I’ll click on the vertical column of numbers forming the scale of the left-hand Y-axis. Now I can enter my own choice of minimum and maximum value for the axis (I could also change the font settings, if I wanted to). I’ll enter 0 for the minimum, and leave the maximum set to the default value of Max, so it automatically scales the upper bound to suit the data:

Click image to enlarge

Click image to enlarge

Returning to the sheet, my chart is now displayed as I’d like it:

Click image to enlarge

Click image to enlarge