From the course: Excel Tips Weekly

Unlock this course with a free trial

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

Use chart and filter for presentations

Use chart and filter for presentations - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Use chart and filter for presentations

- [Instructor] On this worksheet, 2 we're looking at a stacked column chart and above it, 3 the data, the source data for the chart. 4 A chart always displays visible data and visible data only. 5 You can make a switch to show all data even when hidden. 6 But if I were to hide, for example, Arizona 7 by right clicking row C 8 and then hide, 9 watch the chart, we're not going to be seeing Arizona. 10 It's the light blue column on the right side 11 of each cluster. 12 It's not there anymore. 13 It's not represented in the legend of the chart. 14 We don't see it in the columns. 15 It's not there because that row is hidden. 16 So let's bring it back. 17 Control Z, undo, many of you know if you filter data, 18 you hide rows. 19 So what if we apply a filter here, 20 not just to be hiding rows, 21 but because we're saying something like this, 22 we want to be able to make a presentation of this information. 23 But when needed…

Contents