Join Dennis Taylor for an in-depth discussion in this video Working with hidden data when copying cells and creating charts, part of Excel Tips Weekly.
- [Instructor] At different times…when you're working with Excel Charts…or simply with Excel Data,…you want to hide certain information.…And that has implications.…Not only in the way that view charts…but also in the way that we see data.…And when we copy data that has hidden information in it,…sometimes we get unexpected results.…Let's first look at some charts.…You'll notice that these two charts…are identical in terms of…the information they are displaying.…Obviously, the charts are different in the design.…Below, the chart on the left we see the phrase…Plot Visible Cells Only.…
And on the right, Plot All Cells.…In Excel, when you create a chart,…the default setting is to show visible cells only.…The chart that we see on the left…and also the one on the right,…are both based on the data we see below,…starting here in row 21.…Now,…if I hide rows 24 and 25.…And I'll simply drag across those two rows,…right-click and Hide,…the chart on the left reacts.…We're not seeing Pennsylvania and Illinois.…
The chart on the right shows all the states…
Note: Because this is an ongoing series, viewers will not receive a certificate of completion.
Skill Level Appropriate for all
Q: Why can't I earn a Certificate of Completion for this course?
A: We publish a new tutorial or tutorials for this course on a regular basis. We are unable to offer a Certificate of Completion because it is an ever-evolving course that is not designed to be completed. Check back often for new movies.
Excel Tips - New This Week
- 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.