Work with empty and hidden cells

- In this worksheet called Line Chart,…you can see that the line chart to the right…is a little bit odd, in a few respects,…and as I click the line chart,…you can see clearly that it's representing the data…to the left,…rows two, three, and four,…Arizona, California, and Colorado data.…And notice also, within the data,…we've got some empty cells.…And there is a concern about how empty cells…are being displayed.…Now, interestingly enough,…if we change this to a column chart, it's going to look…a little bit different.…I'm going to go to the Design tab, first of all,…just change chart type,…I'll make it a column chart,…clustered column.…

We still see some gaps but it still looks a little bit…different, maybe not as obtrusive as it might have…with the line chart,…but there are times when you want this to be a line chart.…I'm going to press control z to undo my last change…to the column chart,…back to a line chart.…On the Design tab is a button called Select Data.…This brings up a dialog box and at first,…it's for fine tuning or possibly adjusting each of these…