Age structure and retirement wave in one chart
A population pyramid plus a five-year retirement projection, driven entirely by formulas so it refreshes with the next export.
Excel (advanced)04 Demographics and diversityAdvanced17 min
The recording for this walkthrough is being published — the files below already contain the full model.
What you will build
- 01Build a population pyramid without add-ins
- 02Project retirements against statutory retirement age
- 03Flag critical roles with a skills coverage matrix
Dataset used
Employee master data with birth year, job family and criticality flag.