Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
You can create a chart in Numbers '09 that uses data from more than one table. Our Running Club spreadsheet has three separate tables, but we can use data from each to create a single chart. First, we select data from one of the tables to create the chart. Let's select the cells beginning with Men's Total in our first table, and drag all the way down to the September row. Now we'll create a chart. Click the Charts button on the Toolbar, and let's create a Mixed Chart, so we can use different chart types.
Automatically our default table appears. We can stretch this out so it's a little bit easier to read some of the labels across the bottom. And now it's time, with our chart selected, to choose some additional data from those other tables. All we do is hold down the Command key on the keyboard while we select the data. Let's click and drag from Women's Total in our second table all the way down to the September row. Notice that data is automatically added to our Mixed Chart. We also want to throw the Goal in there. So holding the Command key on the keyboard, we'll click and drag from Goal all the way down to the September row.
So we now have our data from three separate tables. We can make some modifications to this chart to make it stand out. With the Chart Inspector open automatically when we created the chart, let's select the data series. We'll click the actual series represented by the Line, in this case our Men's Total. Now in the Chart Inspector, click the Series button and make sure that this is actually a Column. Now the one that should appear as a Line is the Goal. It's currently represented by the orange column. So we'll select any orange column, change the Series Type to Line. This is a little bit easier to read.
Of course we can understand it better if we could see the legend, we can turn that on by clicking the Chart button and choosing to show the Legend. It appears across the bottom. We can select it and then drag it into the center where it looks better. Now we'll click anywhere on the canvas to deselect. Close our Chart Inspector to see the end result. So even when your data exists in more than one table, remember you can use data from multiple tables to create a single chart.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 98519 Viewers
80 Video lessons · 141524 Viewers
59 Video lessons · 59886 Viewers
52 Video lessons · 73077 Viewers
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.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.