When you need to display more than one data series but use two different scales, you can create a two-axes chart. Two-axes chart lets you use two different Y-axes each with different scales. Our Energy Saving Plan spreadsheet has a table with data that fits this bill. So let's create a two-axes chart with this table. First we'll select the table. You can click the table name in the Sheets pane. And now we'll create the chart by clicking the Charts button on the Toolbar and selecting 2-axes chart, which appears at the very bottom left-hand side.
This creates a default 2-axes chart. Let's stretch it out, so it's a little bit easier to read. And as you can see it's currently not displaying the data in the best way. The % Increase, which appears at the bottom of our table, should really use a different scale than the year 2007. Notice we have an axes on the left or Y1 axis with a scale and the on the right hand side we have a second Y axis displaying a different scale. So let's fix this up so it looks proper. We'll start by selecting the series for 2007, currently represented by a line.
We can click the line anywhere to select that series. And notice in our Chart Inspector, which opens up automatically by the way, the Series Type is set to Line. We can change this to Column. Now you can see we have got different columns using different scales. 2007 according to our Chart Inspector is plotted on the Y1 axis. But for 2008 it appears to be using a different scale. So let's select that series by clicking any green bar. It should really use the scale on the left. If we look at our Chart Inspector, it's using the Y2 axis.
But we can change that by clicking the button and choosing Value Axis Y1. Now we can see our % Increase represented by the orange bars. Notice it automatically changed the scale on the right to percentages, which is perfect for the type of data displayed in our table. Now let's select that series. This time we'll click the little orange block next to % Increase in the table. That also allows us to select the entire series. Let's change Series Type to Line. Right now it's a Column. When we change it to Line this is probably the best way to view our data. We'll click anywhere on the Canvas to deselect. So there you have it. Data Series in one chart using different Y-axis scales, a great way to combine different types of data.
Get unlimited access to all courses for just $25/month.Become a member
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Your file was successfully uploaded.