From the course: Excel: Charts in Depth

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Waterfall and funnel charts

Waterfall and funnel charts

From the course: Excel: Charts in Depth

Start my 1-month free trial

Waterfall and funnel charts

“

- [Instructor] We're looking at a worksheet called waterfall in our chapter seven exercise file. Just to the right of it is another worksheet that's called funnel. Both of these are located together. When we go to the insert tab when we're in charts group, the upper right corner, we do see an icon here with quite a few different chart types here. A waterfall chart is ideal for showing what's happening month to month, particularly when we're changing, or doing positive and negative data flows. That's when we've got the data turning over in columns A and B. So I'll simply use waterfall here, show the cumulative effect of a series of positive and negative values, and we're seeing this here. The data in column B doesn't really have to be there. Get to that in a moment, but as we look at the data here, we can see pretty clearly, particularly if you're looking at the numbers over in column B, what's happening. The blue…

Contents