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


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!


Supercharge Power BI - 3rd Edition

February 2021

Released in 2021, this book will teach you the DAX language from the ground up, using Power BI as your canvas.


MrExcel 2022 Boosting Excel

April 2022

The 6th Edition of MrExcel XL, updated with new functions released for Microsoft 365.


Power BI for the Excel Data Analyst

July 2022

A step-by-step guide on how to use Power BI. Written with Excel fans in mind, but with every Power BI student at its heart.


see more products »