Join David Rivers for an in-depth discussion in this video Modifying chart data, part of Numbers 3 Essential Training.
On occasion, when you add a chart…to one of your sheets here in Numbers,…you may realize that you've got some data you didn't want…or maybe you missed some data that you did want.…You can always go back and edit the data…that's being used in the chart.…And we're going to do so with this file, KEcoBudget0602,…if you've skipped to this movie.…We left off on the expense report…having added this column chart.…When we select it,…you can see actually what's going on in the chart itself,…the areas that are being used,…including this empty cell over here.…
And as we look at the chart,…there's some empty space.…So if we go to Edit Data References,…we can fix that up.…Let's click the button Edit Data References,…and sure enough,…we can see the data that's being used.…You can see the colors,…and the blue here which is blank or empty,…we can't even see on the chart…because there's no value there.…And in fact, we don't want it.…Somehow it got included when we added this data.…All we want to do is remove it,…so click right in that data area.…
- Creating and laying out spreadsheets
- Importing data
- Working with tables
- Adding images to cells
- Performing calculations with formulas and functions
- Creating charts
- Formatting text and numbers
- Including audio, video, and shapes
- Designing templates
- Printing and sharing spreadsheets
Skill Level Beginner
1. Getting Started with Numbers
2. Working with Spreadsheets
3. Working with Tables
4. Working with Table Styles
5. Using Formulas and Functions
6. Working with Charts
7. Working with Text and Numbers
8. Working with Objects
9. Creating Your Own Templates
10. Sharing Your Spreadsheets
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.