From the course: Excel 2016: Charts in Depth
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Work with empty and hidden cells
From the course: Excel 2016: Charts in Depth
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
Add a chart element3m 58s
-
Choose a chart layout with the QuickLayout option3m 55s
-
Select chart colors using Colorful and Monochrome palettes3m 38s
-
Style charts using the Design gallery or paintbrush icon2m 32s
-
Switch rows and columns for a different view of the data3m 17s
-
Change the location of a chart's source data4m 7s
-
Work with empty and hidden cells6m 22s
-
Change a chart's type2m 22s
-
Change the default chart type and save it as a template4m 54s
-
Change the location of a chart1m 39s
-
Move and resize a chart within a worksheet5m 6s
-
-
-
-
-
-
-
-
-