Funnel Chart Explained: How to Make, Read and Report It
A funnel chart shows how a quantity shrinks across ordered stages, such as people screened, eligible, enrolled and retained. This guide covers the sequential-stage funnel; it is not the funnel plot used in meta-analysis to examine publication bias, which is a different graph.
What it shows
Bars (or trapezoids) are stacked from the largest stage at the top. Two quantities matter: the stage-to-stage conversion rate, ni+1/ni, and the overall yield, nlast/nfirst. Overall yield equals the product of the stage conversions.
Original example (illustrative)
A study screens 1,000 people: 600 are eligible, 420 consent, and 336 complete the protocol.
| Stage | n | Conversion from previous | Lost |
|---|---|---|---|
| Screened | 1,000 | ||
| Eligible | 600 | 60% | 400 |
| Consented | 420 | 70% | 180 |
| Completed | 336 | 80% | 84 |
Overall yield is 336/1,000 = 33.6%, matching .60 × .70 × .80 = .336. The largest absolute loss is at eligibility (400 people), while the lowest conversion is also at eligibility (60%). These two measures do not always point to the same stage, so report both.
How to make it in StatFAS
Open the Funnel Chart Generator. Provide stage labels in order and a numeric value for each.
Reading and reporting
Keep stages in logical order, make sure each stage is a subset of the previous one, and state the denominator. In clinical research, a CONSORT-style flow diagram with reasons for exclusion is the reporting standard for trials (Schulz et al., 2010), and a funnel chart is a simpler visual complement. Caption: Figure 1. Participant flow from screening to completion (N = 1,000 screened).
Common mistakes and alternatives
Using non-nested stages, mixing units across stages, omitting why people were lost, confusing it with the meta-analysis funnel plot, and judging bar areas rather than numbers. Alternatives: bar charts of stage counts, flow diagrams and tables. See descriptive statistics and charts for general summaries.
Conclusion
A funnel chart makes attrition across stages visible; report counts, conversion rates and reasons for loss together.
1.
statfas-funnel-chart-interface.png, alt: "StatFAS Funnel Chart Generator interface"2.
statfas-funnel-chart-example-data.png, alt: "Example data entered in the StatFAS Funnel Chart Generator"3.
statfas-funnel-chart-settings.png, alt: "Funnel Chart Generator settings in StatFAS"4.
statfas-funnel-chart-result.png, alt: "Funnel Chart Generator result generated in StatFAS"References
- Schulz, K. F., Altman, D. G., & Moher, D. (2010). CONSORT 2010 statement: Updated guidelines for reporting parallel group randomised trials. BMJ, 340, c332.