Short answer: the funnel chart shows how many survive each stage of an ordered process and, crucially, where the biggest drop-off is. In a brewery it maps the sales pipeline (leads → listings → repeat orders), the new-product stage-gate (ideas → brewed → launched), and trade-promotion conversion. Its value is spotting the leakiest stage; its risk is that the tapering shape flatters and can mislead, so label every stage with its count and conversion rate rather than trusting the silhouette.
Part of The Brewer’s Chart Field Guide. It’s a specialized view of ordered-stage attrition — a stacked, centred cousin of the bar chart.
When to reach for it
Reach for a funnel when items pass through genuinely sequential stages and the question is “where do we lose them.” The narrowing makes attrition vivid and points at the stage worth fixing.
Use case 1 — The sales pipeline
Leads → listings → first order → repeat. The funnel shows where your distribution effort leaks — often the listing-to-first-order gap — guiding sales intelligence effort to the stage that pays.
Use case 2 — The NPD stage-gate
Ideas → shortlisted → pilot-brewed → launched → retained. The funnel exposes how few ideas survive and at which gate they die — the backbone of a disciplined beer NPD process.
Use case 3 — Trade-promotion conversion
Displays placed → uplift achieved → repeat purchase. It shows whether promotions convert to lasting demand or just a one-off blip — a sharper read than a single uplift number.
Where this breaks
Stages must be sequential — if items skip or re-enter stages, a funnel misrepresents them; use a different view. Shape flatters — the taper can imply smooth, inevitable loss; label counts and conversion rates. A bar chart is often clearer — for exact comparison, sorted bars beat the funnel; use the funnel when the attrition metaphor genuinely helps. Vanity framing — a wide top makes a weak pipeline look busy; focus on conversion, not raw top-of-funnel.
The bottom line
The funnel chart reveals stage-to-stage survival and the leakiest step — in the sales pipeline, the NPD gate, promotion conversion. Use it only for genuinely sequential stages, label each with count and conversion, and switch to bars when precise comparison matters. Next, the single-number-vs-target view: the gauge and KPI card.
Frequently asked questions
When should a brewery use a funnel chart? When something passes through ordered stages and you want to see how many survive each one and where the biggest drop-off is — a sales pipeline (leads to listings to repeat orders), a new-product stage-gate (ideas to brewed to launched), or trade-promotion conversion (displays to lift to repeat). The funnel makes the leakiest stage obvious so you know where to focus.
What is the difference between a funnel chart and a bar chart? A funnel is essentially a set of stacked, centred bars for an ordered sequence of stages, emphasising the narrowing as items drop out. A sorted bar chart shows the same counts and is often clearer for exact comparison; choose a funnel when the stage-to-stage attrition and the “narrowing” metaphor genuinely help the audience grasp a process.
What is misleading about funnel charts? The tapering shape can imply a smooth, inevitable narrowing and can exaggerate or flatten real differences depending on whether width is scaled by value. Stages must be genuinely sequential — if items can skip or re-enter stages, a funnel misrepresents them. Always label each stage with its count and conversion rate rather than trusting the shape.