How to Create a Funnel Chart in Excel 2016

News
By published

Funnel charts are often used in sales, marketing, and other departments to show data through different stages in a process, such as prospective clients moving through the sales pipeline. A recent update to Office 2016 makes it dead simple to create a funnel chart in Excel.

This new feature is available for Office 365 subscribers.

1. Select your data in Excel. It should have a row for each stage of the process and a column for the values.

2. Click the Insert tab.

3. Click Insert Waterfall or Stock Chart > Funnel.

Excel will insert the funnel chart for you. Double-click in the chart to format the bars and other design elements of the funnel chart, or go to the Design and Format tabs to quickly customize the chart's appearance.

Microsoft Excel Tips

Melanie Pinola
Latest in Work & Collaboration Tools
An illustration of a man's silhouette and the top of his head is open like a lid as a slew of app icons float out into the air. The illustration is on a flat orange background.
I found an app that connects all my apps — without trying to replace them. It's a life-changer.
Thunderbolt Share depiction
Intel Thunderbolt Share: The powerful PC-to-PC connection software is frustratingly elusive, but you don't need a new laptop to use it
The 39.7-inch Dell UltraSharp monitor beside a Laptop Mag deals icon in front of an orange and yellow background
Top 5 Dell UltraSharp monitor deals: Save up to $300 on the ultimate productivity monitor!
The Logitech MX Creative Console seen from above on a white table
Logitech MX Creative Console review: Is this alternative stream deck a creative game changer?
Google Search
Google Reverse Image Search: How to search with an image in Google
docs in proton drive
What is Proton Docs? Why you might want to give the privacy-focused Google competitor a chance
Latest in News
Nintendo switch 2 virtual game card
Nintendo's Virtual Game Card feature might be more revolutionary than the Switch 2
A close-up of a light-colored computer keyboard shows the keys T, Y, G, and H replaced by the logos of OpenAI, DeepSeek, Grok, and Gemini, the leading competitors in the artificial intelligence market. This serves as a visual metaphor for the intense rivalry and innovation in the AI industry. (Photo by Matteo Della Torre/NurPhoto via Getty Images)
Is generative AI inadvertently reducing the voices of many to the banality of one?
Asus ROG Ally Z1 on a brown table with the game Unpacking played on screen.
Handheld gaming PCs have a Windows problem — but maybe not for long
WWDC 2025 could mark the beginning of the end for certain iPhone users
Error when installing Google Chrome on the Asus Vivobook 16 Flip, on a white desk against a blue background.
"This app can't run on your PC": Google's Chrome Installer broke on Windows, but there's a fix
Nintendo Switch 2 handheld gaming console
Nintendo Switch 2 preorder date: It might be a lot closer than you think, say tipsters
More about work collaboration tools
An illustration of a man's silhouette and the top of his head is open like a lid as a slew of app icons float out into the air. The illustration is on a flat orange background.

I found an app that connects all my apps — without trying to replace them. It's a life-changer.
Thunderbolt Share depiction

Intel Thunderbolt Share: The powerful PC-to-PC connection software is frustratingly elusive, but you don't need a new laptop to use it
Beats Studio Pro headphones on a wooden table next to a laptop.

Best Buy is slashing up to $170 off Beats audio gear for a limited time, here are 5 deals I recommend
See more latest