Waterfall Chart for Headcount Changes — Hiring, Attrition & Org Bridge
A headcount waterfall chart bridges starting full-time equivalents ($FTE_{start}$) to ending workforce size ($FTE_{end} = FTE_{start} + Hires + Transfers - Attrition$) across an operating period.
Tip: Paste Excel or Google Sheets rows (Ctrl+V / ⌘V) directly into any cell.
| # | Label | ||
|---|---|---|---|
| 1 | |||
| 2 | |||
| 3 | |||
| 4 | |||
| 5 | |||
| 6 | |||
| 7 |
Ending FTE = Opening FTE + Gross Additions - Gross Separations. Annualized Attrition Rate = (Separations / Average FTE) * 100%.
Chart Design & Use-Case Tips
- 01Ending FTE = Opening FTE + Gross Additions - Gross Separations. Annualized Attrition Rate = (Separations / Average FTE) * 100%.
- 02Enter Opening FTEs in Row 1, positive numbers for hiring/acquisitions, and negative numbers for voluntary/involuntary departures.
- 03The anchored Net Total bar at the right displays Ending FTEs (510 FTEs in the default example).
- 04Ideal for CHRO / People Ops quarterly board slides and capacity planning.
Frequently Asked Questions
Why is a waterfall chart better than a line chart for headcount reporting?+
A line chart only shows net headcount (e.g., growing from 420 to 510), hiding whether you hired 90 people with 0 churn or hired 133 people while losing 43 to attrition.
How do I calculate net hiring velocity from the chart?+
Subtract Opening FTEs (Row 1) from the Net Total readout (Sum in the telemetry bar) to see net FTEs added during the period.
Can I use this for departmental budget FTE walks?+
Yes, replace the step labels with department names to show how net headcount expansion is distributed across teams.