Funnel Chart Maker — Stage-by-Stage Conversion & Drop-Off Visualizer
A funnel chart renders sequential pipeline stages as centered horizontal trapezoids whose widths scale proportionally to stage volume ($W_k \propto N_k / N_1$), highlighting both cumulative conversion ($N_k / N_1$) and stage-over-stage drop-off.
Tip: Paste Excel or Google Sheets rows (Ctrl+V / ⌘V) directly into any cell.
| # | Label | ||
|---|---|---|---|
| 1 | |||
| 2 | |||
| 3 | |||
| 4 | |||
| 5 | |||
| 6 |
Top-of-funnel conversion at stage k: Conv_k = (N_k / N_1) * 100%. Step-to-step retention: Step_k = (N_k / N_{k-1}) * 100%. Stage drop-off: Drop_k = 100% - Step_k.
Chart Design & Use-Case Tips
- 01Top-of-funnel conversion at stage k: Conv_k = (N_k / N_1) * 100%. Step-to-step retention: Step_k = (N_k / N_{k-1}) * 100%. Stage drop-off: Drop_k = 100% - Step_k.
- 02Order funnel rows strictly from the top of the funnel (largest initial volume) down to the final conversion event.
- 03Look for the steepest trapezoidal narrowing between two consecutive stages to pinpoint your highest-leverage conversion bottleneck.
- 04Keep Data Labels toggled ON to display both raw volume and percentage of top-of-funnel right inside each stage tier.
Frequently Asked Questions
What is the difference between overall conversion rate and step conversion rate?+
Overall conversion divides a stage's count by the very first stage (N_k / N_1), whereas step conversion divides a stage's count by the immediately preceding stage (N_k / N_{k-1}). Both are surfaced in the hover tooltip.
How many stages should a funnel chart include?+
Four to seven sequential stages provide the clearest visual taper and actionable conversion diagnostics.
Can I use Funnel Chart Maker for B2B sales pipeline dollars?+
Yes—enter pipeline dollar value or opportunity count per stage, or open the dedicated Funnel Chart for Sales Pipeline template.