Funnel Chart Maker for Attrition and Participant Flow
Use this tool to see how many participants, samples or variants remain at each stage of a pipeline, for example screening to analysis in a trial, variant filtering, or a diagnostic cascade. Upload your data below (CSV or Excel, or paste it) with a stage column and a count column, then press the button to generate the chart.
About the funnel chart
A funnel chart shows how a count shrinks stage by stage, from the first stage to the last. In research it is used for participant flow and attrition (enrolled, randomised, completed, analysed), for bioinformatics filtering steps, and for diagnostic cascades. The width of each bar is proportional to the count remaining, and the percentage retained from the previous stage is shown between bars.
When to use it
Use it when you have counts that can only stay the same or fall from one stage to the next and you want to know where most participants or records are lost, whether any stage loses more than expected, and whether two groups or trial arms differ in how they are retained.
What this tool reports
Stage-by-stage retention, retained from the previous stage and cumulative, with exact Clopper–Pearson confidence intervals.
Bottleneck tests: each stage’s retention against the geometric-mean retention across stages (exact binomial tests, Holm-corrected) and a heterogeneity test.
For several groups or trial arms, a between-group comparison of retention at each stage.
The funnel chart as a figure and an APA 7 results paragraph with APA 7 tables, ready to download as Word, PNG, SVG or CSV.
Assumptions to check
Each stage is a subset of the previous one, so counts do not increase. The tool warns you when they do.
Records are independent, and the count at each stage is a whole number.
Percentages retained are relative to the previous stage; cumulative percentages are relative to the first stage.
How to report it in APA7
Report the starting and final counts with the overall percentage retained and its confidence interval, name the stages where retention was lower than expected, and give the test statistics with adjusted p values. The tool writes this paragraph for you and lays out the tables in APA 7 style.
Frequently asked questions
Is the Funnel Chart Maker free?
Yes. You can run the analysis and read the results without an account. Create a free account or log in only when you want to download the results.
What data do I need?
A stage column in funnel order, a count column with the number remaining at each stage, and optionally a group column such as treatment arm with one row per stage per group.
What is a bottleneck stage?
A stage where retention is significantly lower than the typical retention across all stages, based on exact binomial tests with Holm correction.
Is my data uploaded to a server?
The analysis runs in your browser. Your data stays on your device while you use the tool.