Human Resources chart template
Employee Turnover Chart Template
Monthly employee turnover rate for sales, engineering and customer support over twelve months.
Track monthly employee turnover for each department on one line chart. The template compares sales, engineering and customer support over twelve months, with turnover shown as a percent of each department's headcount.
Employee Turnover by Department
A live grouped line chart drawn from the sample data below. Click Edit this template to change it.
About this template
What the employee turnover by department chart shows
Customer support has the highest turnover in the sample, averaging 3.3% a month, followed by sales at 2.5% and engineering at 1.0%. All three departments peak in December, when support reaches 4.4%.
Support turnover falls steadily through the first half of the year, from 3.8% in July to 2.5% in June. Separate lines per department show changes like this that a single company wide rate would hide.
About the sample data
Turnover counts every voluntary and involuntary departure in the HR system, divided by the department's average headcount for the month. Interns and contractors are left out, and a transfer between departments counts as staying.
Sample data
Sample data for the employee turnover by department template
The template loads these 36 rows. Keep the same columns, replace the rows with your own numbers, and the grouped line chart redraws to match.
Month
Time axis
Department
Breakdown, one color per value
Turnover Rate (%)
Values
| Month | Department | Turnover Rate (%) |
|---|---|---|
| 2025-07-01 | Sales | 2.6 |
| 2025-08-01 | Sales | 2.9 |
| 2025-09-01 | Sales | 3.1 |
| 2025-10-01 | Sales | 2.4 |
| 2025-11-01 | Sales | 2.2 |
| 2025-12-01 | Sales | 3.4 |
| 2026-01-01 | Sales | 2.8 |
| 2026-02-01 | Sales | 2.5 |
| 2026-03-01 | Sales | 2.3 |
| 2026-04-01 | Sales | 2.1 |
| 2026-05-01 | Sales | 2 |
| 2026-06-01 | Sales | 2.2 |
| 2025-07-01 | Engineering | 1.1 |
| 2025-08-01 | Engineering | 0.9 |
| 2025-09-01 | Engineering | 1.2 |
| 2025-10-01 | Engineering | 1 |
| 2025-11-01 | Engineering | 0.8 |
| 2025-12-01 | Engineering | 1.4 |
| 2026-01-01 | Engineering | 1.1 |
| 2026-02-01 | Engineering | 0.9 |
| 2026-03-01 | Engineering | 1 |
| 2026-04-01 | Engineering | 0.8 |
| 2026-05-01 | Engineering | 0.9 |
| 2026-06-01 | Engineering | 0.7 |
| 2025-07-01 | Customer Support | 3.8 |
| 2025-08-01 | Customer Support | 4.1 |
| 2025-09-01 | Customer Support | 3.6 |
| 2025-10-01 | Customer Support | 3.3 |
| 2025-11-01 | Customer Support | 3.1 |
| 2025-12-01 | Customer Support | 4.4 |
| 2026-01-01 | Customer Support | 3.5 |
| 2026-02-01 | Customer Support | 3.2 |
| 2026-03-01 | Customer Support | 2.9 |
| 2026-04-01 | Customer Support | 2.7 |
| 2026-05-01 | Customer Support | 2.6 |
| 2026-06-01 | Customer Support | 2.5 |
How to use it
How to adapt the employee turnover by department template
- 1 Click Edit this template to open the chart and its sample data in the InstaCharts chart maker. No account is needed.
- 2 Calculate each month's rate as departures divided by the department's average headcount, then enter one row per department per month.
- 3 Count voluntary and involuntary departures the same way every month, or split them into two series.
- 4 Add an average trend line from the chart options to mark the typical monthly rate.
- 5 Switch to a grouped bar chart to compare annual turnover by department instead of the monthly trend.
- 6 Download the chart as a PNG, SVG or PDF, share it with a link, or embed it on a website. Sign up free to save it.
FAQ
Employee Turnover by Department template FAQ
How do I calculate employee turnover rate for the chart?
Divide the number of employees who left during the month by the average headcount for that month, then multiply by 100. Enter the result as one row per department per month.
Can I chart voluntary and involuntary turnover separately?
Yes. Add a Type column with Voluntary or Involuntary and switch to a stacked bar chart, or filter the sheet to one type for the line chart.
What chart is best for employee turnover?
A line chart shows turnover trends over time, and a bar chart compares turnover across departments for a single period. This template uses lines so each department's trend is easy to follow.
Is this chart template free?
Yes. Click Edit this template to open it in the InstaCharts chart maker with no account needed. Sign up free to save the chart, share it with a link or embed it on a website.
How do I use my own data with this template?
Open the template in the chart maker, then paste in your own spreadsheet or upload a CSV or Excel file with the same kind of columns. The new chart keeps this template's grouped line chart type, and you can pick which columns go on each axis.
Learn more about this chart type on the grouped line chart maker page.
More templates
Related chart templates
Employee Satisfaction Survey
Radar ChartSurvey scores across compensation, work-life balance, management, growth and culture for three teams.
View templateEmployee Engagement Survey
100% Stacked Bar ChartAgreement levels for five engagement statements, stacked into horizontal bars so each question reads as one row.
View templateNet Promoter Score Trend
Line ChartNet Promoter Score from the in-app survey for each month over the last year.
View templateMonthly Operating Expenses
Area ChartTotal operating expenses for each month over a full year.
View templateCash Flow Waterfall
Waterfall ChartNet cash flow for each month of the year, shown as a waterfall of rises and drops building toward the ending balance.
View templateStock Price Trend
Line ChartDaily closing price for a sample stock ticker over several weeks of trading.
View templateSee all HR Chart Templates, or browse all chart templates.
Make your own grouped line chart in seconds
InstaCharts makes data visualization easy, so you can build clear reports without design experience.