What Is a Funnel Chart? Definition, Examples, and When Not to Use One (2026)
A funnel chart shows values across the successive stages of a process, drawn as horizontal bars that narrow as the count drops. Microsoft's own description is direct. Funnel charts "show values across multiple stages in a process," such as the number of sales prospects at each stage in a pipeline.
The shape is doing a specific job. It encodes drop-off — the visual narrowing is the message, and the eye finds the biggest single loss faster than it would in a table. That works beautifully when the data really is one cohort moving through ordered stages, and it misleads badly when it is not.
This guide covers what the form is for, how to build one in Excel, and how it compares with the alternatives. It closes with the situations where reaching for it produces a confident but wrong picture.
What is a funnel chart?
A funnel chart is a stage-based visualization. Each bar represents one step in a sequential process, and the length of the bar represents how many items remain at that step. Stages are ordered top to bottom, from the largest population to the smallest.
Two properties define it. The stages are sequential — you cannot reach stage three without passing stage two. And the population is monotonically decreasing — each stage holds a subset of the one above it. When both hold, the narrowing shape carries real information. When either fails, the shape is decoration at best.
The chart usually shows two derived numbers alongside the raw counts. Those are the conversion rate from one stage to the next, and the overall conversion from first stage to last.
What a funnel chart is used for
Sales pipelines. The classic use, and the one Microsoft cites. Prospects move from lead to qualified to proposal to closed, and the chart shows where deals die.
Product onboarding. Users who signed up, activated, completed setup, and returned in week two. This is where the form most often changes a decision, because the largest drop-off is rarely where the team assumed.
Recruitment. Applications received, screened, interviewed, offered, accepted. The stages are genuinely sequential and the population genuinely shrinks, so the form fits.
Order fulfilment. Carts created, checkouts started, payments authorized, orders shipped. Each step gates the next.
The pattern across all four is the same: an ordered process, a single cohort, and a question about where the losses concentrate. If your data does not have all three, the shape will still render. It just will not mean what readers assume it means.
How a funnel chart works
The stages carry the order
The vertical sequence is not sortable by size — it is fixed by the process itself. This distinguishes the form from a bar chart, where reordering categories by value is normal and often helpful. Reordering funnel stages destroys the meaning.
The widths carry the counts
Bar length is proportional to the value at each stage, centred so the outline forms the funnel silhouette. This is also the source of the form's most common misreading. The area between two bars looks like it represents the loss, but only the length difference actually does. Steep visual tapers can suggest a bigger drop than the numbers support.
The rates carry the insight
The raw counts tell you how many. The stage-to-stage conversion rates tell you where the problem is. A funnel losing 40% at one step and 5% at the next four has one problem, not five. That is visible only when the rates are labelled.
How to make a funnel chart in Excel
Excel has a native chart type for this. Lay out the data in two columns — one for the stage names, one for the values — with stages in process order.
In Excel for Windows, select Insert > Insert Waterfall, Funnel, Stock, Surface or Radar chart > Funnel. On Excel for Mac, select the Insert tab, then the Waterfall icon, and choose Funnel.
Availability is version-dependent, and Microsoft states it plainly. On Windows the feature requires Office 2021 or a Microsoft 365 subscription. On Mac it requires Office 2021 for Mac, Office 2024 for Mac, or a Microsoft 365 subscription. On older builds, the usual substitute is a stacked bar chart with an invisible spacer series — workable, but fiddly to maintain.
Funnel chart vs. bar chart vs. waterfall chart
| Funnel chart | Bar chart | Waterfall chart | |
|---|---|---|---|
| Shows | Remaining count per stage | Value per category | How a total changed |
| Order | Fixed by process | Sortable | Fixed by sequence |
| Data must shrink | Yes | No | No |
| Best question | Where do we lose people? | Which category is largest? | What drove the change? |
The choice usually comes down to one question. If categories are independent, use a bar chart. If you are explaining movement between two totals, including increases, use a waterfall chart. Use the funnel form only when a single population passes through ordered stages.
When not to use a funnel chart
When the stages are not the same people. This is the most frequent error. Counting "visitors this month" against "purchases this month" puts two different populations in one funnel. Some buyers visited last month, and some visitors will buy next month. The chart implies a cohort relationship that the data does not support. Fix it by tracking one cohort forward through time.
When a stage can gain members. Funnels assume monotonic decrease. If users can re-enter a stage, or a deal can move backwards from proposal to qualification, the shape breaks. A stage showing more entries than the one above it produces a chart that widens, which is visually nonsensical.
When there are only two stages. Two bars is not a funnel, it is a comparison. A single conversion rate stated as text communicates more than a chart with two rows.
When the drop-offs are tiny. If every stage retains 95%, the funnel looks like a rectangle and the visual encoding conveys nothing. A table of conversion rates is more honest and more readable.
How to build one from your own data with Powerdrill Bloom
Step 1: Upload your data
Upload the event log, CRM export or product analytics CSV. Powerdrill Bloom profiles the columns, so you can confirm you have a stage field and a consistent identifier before building anything. That identifier is what makes a genuine cohort funnel possible.
Step 2: Describe the chart in natural language
Describe the funnel you need: count distinct users at each stage in this order, then show the conversion rate between consecutive stages. Ask whether the same users appear at every stage, which is the check that catches the cohort mistake before it reaches a slide.
Step 3: Export the chart, report, or deck
Take the funnel out as an image, or drop it into a report with the conversion rates written out. It can also go straight to slides for the review meeting.
Best practices
Label the conversion rate on every stage. The counts show scale; the rates show where the problem is. A funnel without rates makes readers do division in their heads.
Confirm the cohort before you plot. Every stage should count the same population moving forward. If you cannot join stages on a shared identifier, you do not have a funnel — you have four separate counts.
Keep stages between four and seven. Fewer and a table is clearer. More and the lower bars become too small to read.
State the time window. "Signups to activation within 7 days" is a measurable claim. "Signups to activation" is not, because the answer keeps improving as time passes.
Do not fill gaps with estimates. A stage nobody instrumented should be marked as unmeasured rather than interpolated. An invented number in a funnel propagates into every rate below it.
Conclusion
The funnel form is the right tool for one specific shape of data: a single cohort moving through ordered, shrinking stages. Used there, it shows the largest drop-off faster than any table. Used on independent categories or mismatched populations, it produces a picture that looks authoritative and is not.
Your raw data is often an event log or a CRM export rather than a tidy stage table. The work is in getting to that table. Try Powerdrill Bloom on the export and let the cohort check happen before the chart. See also our AI graph maker and the walkthrough for turning a CSV file into a chart. The report-level version of this analysis sits in building a marketing funnel report without SQL.
Frequently asked questions
What is a funnel chart used for?
It shows how many items remain at each stage of a sequential process, making the largest drop-off immediately visible. Common uses are sales pipelines, product onboarding, recruitment stages and order fulfilment — anywhere one population passes through ordered steps.
What is the difference between a funnel chart and a bar chart?
Funnel stages are fixed in process order and each stage must be a subset of the one above. Bar chart categories are independent and can be reordered by value. Use a bar chart whenever the categories do not form a sequence.
How do I create a funnel chart in Excel?
Put stage names in one column and values in another, then select Insert > Insert Waterfall, Funnel, Stock, Surface or Radar chart > Funnel. The feature requires Office 2021 or Microsoft 365 on Windows, and Office 2021 for Mac, Office 2024 for Mac, or Microsoft 365 on Mac.
Can a funnel chart show an increase between stages?
Not meaningfully. The form assumes each stage holds a subset of the previous one, so a stage that grows produces a shape that widens and misreads. If your process allows re-entry or backward movement, a bar chart or a flow diagram fits better.
How many stages should a funnel chart have?
Four to seven works best. With fewer than four, a table or a single conversion rate communicates more. With more than seven, the lower bars get too small to compare and the labels start to collide.