When I first started working in sales operations, I was handed a spreadsheet showing how many leads dropped off at each stage of the sales pipeline — leads, qualified leads, proposals, negotiations, closed deals. A bar chart technically worked, but it didn’t visually communicate the idea of narrowing down, of a “funnel.” Switching to an actual funnel chart made the drop-off at each stage immediately obvious, and it’s become one of my favorite charts for any process with sequential stages.
What Is a Funnel Chart?
A funnel chart displays values across sequential stages of a process, with each stage represented as a horizontal bar that narrows (or widens) based on its value relative to the stage before it. The classic shape — wide at the top, narrow at the bottom — visually represents attrition or progression through a multi-step process.
It’s called a “funnel” because that’s literally what it looks like when your values decrease at each stage, just like a real funnel narrowing toward the bottom.
When Should You Use a Funnel Chart?
I use funnel charts specifically when:
- I’m tracking a sales pipeline from lead to closed deal
- I want to show conversion rates through a multi-step process (website visits → sign-ups → purchases)
- I’m visualizing a hiring pipeline (applicants → interviews → offers → hires)
- Any process where values naturally decrease (or increase) across sequential stages
If your data doesn’t represent sequential stages of a single process, a funnel chart won’t make sense — stick to a bar chart instead.
Required Data Structure
You need two columns: the stage name and the corresponding numeric value. Order matters here — Excel plots stages top to bottom in the order they appear in your spreadsheet, so list them in the sequence you want displayed. Here’s an example:
| Stage | Count |
|---|---|
| Website Visitors | 10000 |
| Leads Captured | 3200 |
| Qualified Leads | 1400 |
| Proposals Sent | 600 |
| Deals Closed | 210 |
Step-by-Step Instructions
Here’s how I build one every time:
- Arrange your data with stages listed in sequential order (largest value typically first) and their corresponding values in the adjacent column.
- Select the data range, including headers.
- Go to the Insert tab.
- In the Charts group, click Insert Waterfall, Funnel, Stock, Surface, or Radar Chart.
- Choose Funnel from the dropdown.
- Excel builds the chart, with the widest bar at top representing your largest value and progressively narrower bars below.
Formatting and Settings I Adjust
Once the base chart appears, here’s what I typically clean up:
- Data labels: I always turn these on (right-click a bar > Add Data Labels) so viewers can see exact numbers, not just relative width.
- Percentage labels: For an added layer of insight, I sometimes manually calculate the conversion percentage between stages in a helper column and reference it in custom data labels, since Excel’s funnel chart doesn’t calculate stage-to-stage percentage automatically.
- Color per stage: Right-click any individual bar and use Format Data Point to assign a unique color if you want each stage visually distinct, or keep a single gradient color for a cleaner look.
- Bar spacing: Under Format Data Series, I sometimes adjust the gap width for a tighter or looser funnel shape depending on how many stages I have.
A Practical Example
Let’s say I’m reporting on an e-commerce checkout process: 10,000 people add an item to cart, 6,500 start checkout, 4,200 enter payment info, and only 3,100 complete the purchase. Plotted as a funnel chart, the drop-offs at each stage are immediately visible — the biggest narrowing happens between “add to cart” and “start checkout,” which tells the team exactly where to focus optimization efforts. That kind of insight is far less obvious in a plain table of numbers.
Common Mistakes to Avoid
Mistakes I’ve made or seen others make:
- Values not in descending order: While Excel will still plot non-sequential values, the funnel shape only makes visual sense when stages generally decrease — an increase midway through looks like a strange bulge and can confuse viewers.
- Too many stages: More than six or seven stages makes the chart cramped and hard to label clearly. Consider consolidating minor stages.
- No labels: Without data labels, viewers can only judge relative size, not actual numbers — always label your bars.
- Confusing stage names: Keep stage labels short and consistent (e.g., “Leads” not “Total Number of Leads Generated This Month”) so they fit cleanly within the chart.
Troubleshooting Tips
If your funnel chart isn’t working as expected:
- Funnel option is missing: Funnel charts require Excel 2016 or later (specifically, this feature was added via a later update, so make sure Office is fully updated).
- Bars aren’t narrowing properly: Check that your values are actually decreasing in the order listed — Excel scales bar width to value, so out-of-order data will look irregular.
- Labels are cut off: Widen the chart or reduce label font size under Format Data Labels.
- Chart looks too squished vertically: Increase the chart’s height, or reduce the number of stages if you have many.
Real-World Use Cases
I’ve used funnel charts for:
- Sales pipeline reporting from lead to closed deal
- Marketing conversion funnels (impressions → clicks → sign-ups → purchases)
- Recruitment pipelines (applications → interviews → offers → hires)
- Event registration flows (invited → registered → attended → engaged)
Each time, the funnel shape communicated the concept of narrowing progression far more intuitively than a standard bar or column chart could.
Best Practices
Before I finalize a funnel chart, I always check:
- Stages are listed in the correct sequential order
- Data labels are visible and show meaningful numbers (and ideally percentages of the top stage)
- The chart isn’t overloaded with more than six or seven stages
- Colors are either consistent (single gradient) or intentionally varied to highlight specific stages
- The chart title clearly states what process is being tracked and over what time period
Funnel charts are deceptively simple to build but incredibly effective at telling a story about progression and drop-off. Once your data is in the right sequential order, Excel does all the visual heavy lifting — you just need to make sure the labels and formatting support the story you’re trying to tell.