Viewers: in countries Watching now:
Numbers offers intuitive organization features, allowing users to focus more on analysis and presentation. In Numbers '09 Essential Training, David Rivers explores the important features of this spreadsheet application and introduces the new tools for formula development and charting. He walks through the new functionality of charts, tables, and templates, and shows how to make spreadsheets effective and eye-catching. Exercise files accompany the course.
In Numbers '09 modifying chart data is as simple as modifying the table where the data resides. We'll continue to use our Energy Saving Plan spreadsheet focusing on our Cost by Month chart that appears up at the top of the page. This is a Mixed Chart that displays the three series of data from our Utility Cost by Month table down below. If we change data in our table, it's instantly reflected in our chart above. Let's click in cell M3 representing the amount for December 2008, and type in 650. When we press Return, look what happens. We see the change in our chart.
Even the Y-axis on the left-hand side has changed to accommodate this larger number. But we can just as easily change the data series to be displayed. For example, if we click the chart anywhere, we'll see the series of data that are being used for this chart, it appears selected in our table down below. Notice the handle down in the bottom right corner, when you move your mouse over it, your pointer turns into a black cross. Now we can change the data series by dragging. Let's move up a single row to select the years 2000 and 2008. We see that change in our chart. But if we want the years 2008 and 2009, we can move to the border of this selected series, and you see the four-sided arrow, click and drag this series down to select the other two years in our table. Automatically the data is updated in the chart above.
If we wanted to view the results for the first half of the year, we could take our handle in the bottom right corner and drag over to select the first six months; January through June. Now let's open up our Chart Inspector, click the Inspector button on the Toolbar, and make sure the Chart Inspector is selected. Let's change our series, for example, 2008, which is currently using an Area chart type, when we select that series we can change it to a Column. Now let's change the 2009 data series, by clicking any one of the green columns and change it to a Line. This might be a better way to compare the different values. Now we'll deselect our chart and table by clicking anywhere on the canvas.
So with charts in Numbers '09 modifying chart data is accomplished through the chart's table.
There are currently no FAQs about Numbers '09 Essential Training.
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.