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.

Chart display options with blank cells in source data

Chart display options with blank cells in source data - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Chart display options with blank cells in source data

“

- [Instructor] On this worksheet we've got two sets of similar data, and columns A and B were showing sales for a company day-by-day for a given month. And you'll see a gap every so often, maybe they don't have sales on Sundays, so we're not showing the 7th, the 14th, the 21st, and so on. In columns L and M, we've got the same data ultimately but we are showing those Sundays here but with no sales. Let's create a chart from the data off to the left. I'll simply click within it. Because it is surrounded by empty cells, we can create a chart quickly, ALT + F1. If you haven't changed the default style, you will get a clustered column chart. And Excel mistakenly uses column A as if it were data. We can easily change that by right-clicking within the chart, selecting select data, and uncheck the box for day. That will be used as labels now across the bottom. So that's a reasonable looking chart. We can make it taller, wider, and…

Contents