Excel 2024: Create Funnel Charts and Filled Map Charts


March 27, 2024 - by

Excel 2024: Create Funnel Charts and Filled Map Charts

In 2016, Microsoft 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.
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.

Early in 2017, Map Charts appeared on the Insert tab in Microsoft 365. A Map chart shades closed regions on a map such as countries, states, counties, even zip code boundaries.

continue reading »

More Reading


Excel 2024: Create Waterfall Charts

Excel 2024: Create Waterfall Charts »

March 25, 2024 - by Bill Jelen


For 12 years, I worked at a company doing data analysis. One of my regular tasks was to analyze the profit on sales proposals before they went out the door. I did this with a waterfall chart. For me, the waterfall chart never would have to dip below the zero axis.

Excel 2024: Show Two Different Orders of Magnitude on a Chart

Excel 2024: Show Two Different Orders of Magnitude on a Chart »

March 21, 2024 - by Bill Jelen


It is nearly impossible to read a chart where one series is dramatically larger than other series. In the following chart, the series for Year to Date Sales is 10 times larger than most of the monthly sales. The blue columns are shortened, and it will be difficult to see subtle changes in monthly sales.

Excel 2024: Create Interactive Charts

Excel 2024: Create Interactive Charts »

March 19, 2024 - by Bill Jelen


It is easy to create interactive charts without using VBA. By default, if you hide rows in Excel, those rows will be hidden in the chart. The technique is to build a chart with every possible customer and then use a slicer or a filter to hide all except one of the customers.

read more articles »

Featured Products


Cool Excel Sh*t

March 2021

Cool Excel Sh*t is designed with the Excel guru in mind, introducing advanced, creative solutions and hacks for the software's most challenging problems.


Microsoft 365 Excel: The Only App That Matters

June 2022

Excel Worksheet, Power Query, Power Pivot, Power BI. Calculations, Analytics, Modeling, Data Analysis and Dashboard Reporting for the New Era of Dynamic Data Driven Decision Making & Insight!


Microsoft Excel VBA and Macros (Office 2021 and Microsoft 365)

April 2022

Use this guide to automate virtually any routine Excel task: save yourself hours, days, maybe even weeks. Make Excel do things you thought were impossible, discover macro techniques you won't find anywhere else, and create automated reports that are amazingly powerful.


Programming PowerPoint with VBA

February 2022

This book assumes you already use PowerPoint and want to automate or enhance your presentations using Visual Basic for Applications (VBA). This book includes VBA samples for working with layouts, themes & masters, creating tables, drawing objects, charting, animation effects and event programming.


see more products »