From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,400 courses taught by industry experts.

Working with hidden data when copying cells and creating charts

Working with hidden data when copying cells and creating charts - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Working with hidden data when copying cells and creating charts

- [Instructor] At different times 2 when you're working with Excel charts 3 or simply with Excel data, you want 4 to hide certain information. 5 And that has implications not only in the way 6 that we view charts, but also in the way that we see data. 7 And when we copy data that has hidden information in it, 8 sometimes we get unexpected results. 9 Let's first look at some charts. 10 You'll notice that these two charts are identical in terms 11 of the information they're displaying. 12 Obviously, the charts are different in the design. 13 Below the chart on the left, 14 we see the phrase plot visible cells only. 15 And on the right, plot all cells. 16 In Excel, when you create a chart, the default setting 17 is to show visible cells only, 18 the chart that we see on the left 19 and also the one on the right are both based on the data 20 we see below starting here in row 21. 21 Now, if I hide rows 24 and 25, 22 and I'll…

Contents