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

Sample data for the Employee Turnover by Department chart template
MonthDepartmentTurnover Rate (%)
2025-07-01Sales2.6
2025-08-01Sales2.9
2025-09-01Sales3.1
2025-10-01Sales2.4
2025-11-01Sales2.2
2025-12-01Sales3.4
2026-01-01Sales2.8
2026-02-01Sales2.5
2026-03-01Sales2.3
2026-04-01Sales2.1
2026-05-01Sales2
2026-06-01Sales2.2
2025-07-01Engineering1.1
2025-08-01Engineering0.9
2025-09-01Engineering1.2
2025-10-01Engineering1
2025-11-01Engineering0.8
2025-12-01Engineering1.4
2026-01-01Engineering1.1
2026-02-01Engineering0.9
2026-03-01Engineering1
2026-04-01Engineering0.8
2026-05-01Engineering0.9
2026-06-01Engineering0.7
2025-07-01Customer Support3.8
2025-08-01Customer Support4.1
2025-09-01Customer Support3.6
2025-10-01Customer Support3.3
2025-11-01Customer Support3.1
2025-12-01Customer Support4.4
2026-01-01Customer Support3.5
2026-02-01Customer Support3.2
2026-03-01Customer Support2.9
2026-04-01Customer Support2.7
2026-05-01Customer Support2.6
2026-06-01Customer Support2.5

How to use it

How to adapt the employee turnover by department template

  1. 1 Click Edit this template to open the chart and its sample data in the InstaCharts chart maker. No account is needed.
  2. 2 Calculate each month's rate as departures divided by the department's average headcount, then enter one row per department per month.
  3. 3 Count voluntary and involuntary departures the same way every month, or split them into two series.
  4. 4 Add an average trend line from the chart options to mark the typical monthly rate.
  5. 5 Switch to a grouped bar chart to compare annual turnover by department instead of the monthly trend.
  6. 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.

Make your own grouped line chart in seconds

InstaCharts makes data visualization easy, so you can build clear reports without design experience.