From the course: Excel Data Visualization: Mastering 20+ Charts and Graphs

Unlock this course with a free trial

Join today to access over 24,200 courses taught by industry experts.

Funnel charts

Funnel charts - Microsoft Excel Tutorial

From the course: Excel Data Visualization: Mastering 20+ Charts and Graphs

Start my 1-month free trial Buy for my team

Funnel charts

“

- [Instructor] All right, next up, we've got one of the simpler charts in Excel, but also one of the new ones introduced in 2016, the funnel chart. Now the funnel chart serves a very simple purpose. All it does is really show progress through stages of a funnel. In other words, it shows progression towards some sort of goal. Examples, maybe you want to see the volume of views, clicks, and sales on an e-commerce site where each of those metrics gets further and further down the funnel. Or maybe you want to look at the number of runners who reach certain check points in a marathon. And that's the example we'll walk through in just a minute. Two quick pro tips here, you can use percent of total calculations to show percentages instead of raw numbers. Sometimes that just tells a more clear story. And second, you always have the option to customize your chart colors. And that can help to emphasize progression towards some sort of an end goal. So let's hop into Excel and take a look. So…

Contents