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:
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:
To fire up the chart editor, I can now use Insert > Chart from the menu:
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.
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:
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:
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:
Returning to the sheet, my chart is now displayed as I’d like it: