Excel 2020: Create Funnel Charts in Office 365

March 18, 2020 - by Bill Jelen

Create Funnel Charts in Office 365. Photo Credit: YIFEI CHEN at Unsplash.com

In 2016, Office 365 introduced Funnel charts, as well as Treemap, Sunburst, Box & Whisker, Pareto, and Histogram charts. A Funnel chart is great for showing a sales funnel.

A funnel chart is like a bar chart where the bars are centered. At the top, there are 500 prospects. The next bar shows 425 qualified prospects. Then 250 of those customers had a Needs Analysis. 150 had price quotes. 100 went to negotiations. Then 90 Close Sales. The bars form the shape of a funnel.

Title Photo: YIFEI CHEN at Unsplash.com

This article is an excerpt from MrExcel 2020 - Seeing Excel Clearly.