Dealing with empty and hidden cells


show more Dealing with empty and hidden cells provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2007: Charts in Depth show less
please wait ...

Dealing with empty and hidden cells

Selecting data for a chart can include hidden rows or hidden columns. Also, it might contain zero values, as we see in this line chart here. But do you want the data in this chart to be depicted regardless of its hidden status, and what do you want to do with those zeroes at times? This chart perhaps is a little bit disconcerting because of the gaps. How might it look if it were column chart? Will that make any differences? Let's check this out here. Click on the Chart, Design tab, change the Chart Type, how about to a clustered column? Double-click that first choice.

We still see the gaps. For some reason, to me that's not as obviously un-appealing as the previous example was. As I press Ctrl+Z here to undo, it looks like that. So maybe that's a question of personal taste. What if we were to hide the columns? Now looking at the data, you would imagine eventually that this missing data should be reported and put into the data, and everything is going to be cleaned up, but for the ...

Dealing with empty and hidden cells
Video duration: 4m 18s 3h 36m Intermediate

Viewers:

Dealing with empty and hidden cells provides you with in-depth training on Business. Taught by Dennis Taylor as part of the Excel 2007: Charts in Depth

Subject:
Business
Software:
Excel
Author:
please wait ...