Headcount, hiring, salaries and performance ratings by department, location and job level, built from an employee roster.
Turn an employee roster into a workforce report. The template builds four KPI numbers, five charts, a roster table and two filters from 152 sample employees.
The sample roster covers six departments and four locations, with each person's job level, employment type, hire date, salary and latest performance rating. Engineering is the largest department with 44 people, and 46 people work remotely.
The average salary is $81,845, ranging from $53,534 for associates to $153,000 for directors. Hiring has picked up since 2022, and 36 people joined in 2026, the most of any year. Marketing has the highest average performance rating at 3.81 out of 5.
Most of the workforce is full time, with 121 full-time employees, 20 part-time and 11 contractors. The Department and Location filters narrow every widget, so a department head can see their own team.
What's included
Every widget on the hr workforce dashboard
The numbers below are what each widget shows for the sample data. Replace the rows with your own and they update to match.
The Department and Location filters sit in the dashboard header. Picking a value narrows every KPI, chart and table on the page.
Data table and notes
The Employee Roster table lists every row of the sample sheet, and a text widget explains what the dashboard shows and how to use the filters.
Sample data
Sample data for the hr workforce dashboard
The template loads 152 rows into a sheet named Employee Roster. Keep the same columns, replace the rows with your own data, and the whole dashboard updates.
Employee ID
ID
Used in Headcount, Hires This Year, Hires by Year
Department
Text
Used in Headcount by Department, Average Performance Rating by Department, Filter: Department
Location
Text
Used in Headcount by Department, Filter: Location
Job Level
Text
Used in Average Salary by Job Level
Employment Type
Text
Used in Employment Type
Hire Date
Date
Used in Hires This Year, Hires by Year
Annual Salary
Currency
Used in Average Salary, Headcount by Department, Employment Type, Average Salary by Job Level
Performance Rating
Number
Used in Average Performance Rating, Average Performance Rating by Department
The first 10 rows of sample data for the HR Workforce Dashboard template
Employee ID
Department
Location
Job Level
Employment Type
Hire Date
Annual Salary
Performance Rating
E-1001
Customer Support
Remote
Senior
Full-time
2018-02-07
$79,000
4
E-1002
Engineering
New York
Mid-Level
Full-time
2018-05-30
$97,500
2
E-1003
Customer Support
Remote
Senior
Full-time
2018-06-16
$72,000
3
E-1004
Finance
New York
Senior
Full-time
2018-08-20
$104,000
1
E-1005
Sales
Austin
Associate
Full-time
2018-09-01
$60,000
4
E-1006
Customer Support
Austin
Manager
Part-time
2018-09-14
$41,500
3
E-1007
Engineering
Austin
Associate
Contract
2018-10-09
$72,500
4
E-1008
Marketing
London
Senior
Full-time
2018-11-28
$102,500
4
E-1009
Engineering
New York
Manager
Full-time
2018-12-27
$163,000
3
E-1010
Finance
London
Mid-Level
Full-time
2019-01-23
$84,500
3
Showing the first 10 of 152 rows.
How to use it
How to build the hr workforce dashboard
1
Click Use this Template
Log in, or create a free InstaCharts account with your email or Google account.
2
Get the finished dashboard
InstaCharts adds the sample sheet to your workspace and builds every KPI, chart, table and filter in the Studio theme.
3
Swap in your data
Switch to Sheets to paste in your own rows or update the sheet from a CSV or Excel file with the same columns.
4
Make it yours
Pick another theme in Dashboard Settings, move or resize widgets, and add more charts, KPIs or text.
Tips for adapting the hr workforce dashboard
Export your employee list from your HR system or payroll tool with one row per person.
Use one ID per employee and leave names out if the dashboard will be shared widely. The headcount KPI counts the ID column.
Keep hire dates in a date format such as 2024-03-15 so the Hires by Year chart and the Hires This Year KPI group them correctly.
Add columns such as gender, tenure band or manager to chart other breakdowns, and add a filter for any column with a small number of values.
An HR dashboard usually shows headcount, hiring, pay and performance, broken down by department, location and job level. This template covers each of these from a single roster sheet.
Can I keep salary data private?
Yes. A new dashboard can only be seen by members of your workspace. Paid plans can also share it with specific people or with a public link, so you decide who sees the salary figures.
Is this dashboard template free?
Yes. Click Use this Template and sign up for a free InstaCharts account, or log in. The hr workforce dashboard is built in your workspace with its sample sheet, widgets and filters. Inside the app, the template is also under New, New Dashboard, Start from a Template.
How do I replace the sample data with my own?
Switch to Sheets in the dashboard toolbar to open the sample sheet. Paste in your own rows or update the sheet from a CSV or Excel file with the same columns, and every chart, KPI and data table on the dashboard updates to match.
Can I change the theme and layout?
Yes. Open Dashboard Settings to pick another theme or customize the header, page and chart colors. Widgets can be moved, resized, duplicated or deleted, and you can add more charts, KPIs, tables and text.
We use cookies to analyze website traffic and optimize your experience. By accepting our use of cookies, your data will be aggregated with all other user data.