HR Dashboard Template

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.

  • 4 KPI numbers
  • 5 charts
  • 2 filters
  • 152 sample rows

HR Workforce Dashboard

Location: AllDepartment: AllHR Workforce DashboardHeadcount152Count of Employee IDHires This Year36▲ 33.3% vs last yearAverage Salary$81,845.39Average of Annual SalaryAverage Performance Rating3.55 / 5Average of Performance RatingHeadcount by DepartmentRemoteNew YorkAustinLondonEngineeringCustomer SupportMarketingHires by Year201820192020202120222023202420252026Employment TypeFull-time80%Part-time13%Contract7%Average Salary by Job LevelSeniorMid-LevelAssociateManagerDirectorAverage Performance Rating by DepartmentMarketingCustomer SupportSalesOperationsEngineeringFinanceEmployee RosterEmployee IDDepartmentLocationJob LevelEmployment T…Hire DateAnnual SalaryPerformance…E-1001Customer Sup…RemoteSeniorFull-time2018-02-07$79,0004E-1002EngineeringNew YorkMid-LevelFull-time2018-05-30$97,5002E-1003Customer Sup…RemoteSeniorFull-time2018-06-16$72,0003E-1004FinanceNew YorkSeniorFull-time2018-08-20$104,0001E-1005SalesAustinAssociateFull-time2018-09-01$60,0004E-1006Customer Sup…AustinManagerPart-time2018-09-14$41,5003E-1007EngineeringAustinAssociateContract2018-10-09$72,5004E-1008MarketingLondonSeniorFull-time2018-11-28$102,5004About this dashboardA roster of 152 sample employees across sixdepartments and four locations, with each person'sjob level, employment type, hire date, salary andlatest performance rating. 36 people joined in 2026and the average salary is $81,845.•Use the Department and Location filters at the topto narrow every widget.•Switch to Sheets to edit the sample roster orpaste in an export from your HR system.

About this template

What the hr workforce dashboard shows

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.

KPI numbers

Headcount

152

Count of Employee ID

Hires This Year

36

Up 33.3% vs last year

Count of Employee ID, compared with last year

Average Salary

$81,845.39

Average of Annual Salary

Average Performance Rating

3.55 / 5

Average of Performance Rating

Charts

Stacked Bar Chart

Headcount by Department

Employees in each department, split by location

Bar Chart

Hires by Year

Employees on the roster by the year they joined

Pie Chart

Employment Type

Share of employees

Bar Chart

Average Salary by Job Level

Mean annual salary at each level

Horizontal Bar Chart

Average Performance Rating by Department

Latest review score out of 5

Filters

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 IDDepartmentLocationJob LevelEmployment TypeHire DateAnnual SalaryPerformance Rating
E-1001Customer SupportRemoteSeniorFull-time2018-02-07$79,0004
E-1002EngineeringNew YorkMid-LevelFull-time2018-05-30$97,5002
E-1003Customer SupportRemoteSeniorFull-time2018-06-16$72,0003
E-1004FinanceNew YorkSeniorFull-time2018-08-20$104,0001
E-1005SalesAustinAssociateFull-time2018-09-01$60,0004
E-1006Customer SupportAustinManagerPart-time2018-09-14$41,5003
E-1007EngineeringAustinAssociateContract2018-10-09$72,5004
E-1008MarketingLondonSeniorFull-time2018-11-28$102,5004
E-1009EngineeringNew YorkManagerFull-time2018-12-27$163,0003
E-1010FinanceLondonMid-LevelFull-time2019-01-23$84,5003

Showing the first 10 of 152 rows.

How to use it

How to build the hr workforce dashboard

  1. 1

    Click Use this Template

    Log in, or create a free InstaCharts account with your email or Google account.

  2. 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. 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. 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.

FAQ

HR Workforce Dashboard template FAQ

What should an HR dashboard show?

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.

Learn how dashboards work on the dashboard maker page, or read the guide on how to create a dashboard.

More templates

More dashboard templates

Product Category: AllRegion: AllSales Performance DashboardTotal Revenue$909.6KTotal of RevenueRevenue This Month$103.3K▼ 3.9% vs last monthOrders266Unique count of Order IDAverage Order Value$3,419.46Average of RevenueMonthly RevenueJanFebMarAprMayJunJulAugSepOctRevenue by RegionEast34%North27%West21%South18%Units Sold by Product CategoryTrainingSoftwareHardwareServicesRevenue by Sales RepMia JohnsonEthan BrooksAva ThompsonSofia GarciaLiam PatelOlivia ChenLucas RiveraNoah KimMonthly Profit by Product CategorySoftwareTrainingHardwareServicesJanFebMarAprMayJunJulAugSepOctProfit by RegionEastNorthWestSouthOrdersOrder DateOrder IDRegionSales RepProduct Cate…UnitsRevenueProfit2026-01-03SO-10001SouthSofia GarciaSoftware5$2,352.20$1,520.752026-01-05SO-10002SouthNoah KimTraining17$2,677.68$1,134.782026-01-06SO-10003EastEthan BrooksHardware5$1,309.96$314.672026-01-07SO-10004EastMia JohnsonSoftware4$1,779.54$992.542026-01-08SO-10005NorthLiam PatelSoftware9$4,249.41$2,715.242026-01-09SO-10006NorthAva ThompsonHardware2$486.93$132.092026-01-09SO-10007WestLucas RiveraTraining20$3,521.51$1,571.472026-01-12SO-10008WestOlivia ChenSoftware8$4,103.75$2,525.59About this dashboard266 sample orders from January to October 2026, with$909,576 in revenue across four regions, eight salesreps and four product categories. East is thelargest region and Software brings in the mostrevenue. Each row is one order with its units,revenue and profit.•Use the Region and Product Category filters at thetop to narrow every widget.•Switch to Sheets to edit the sample orders orpaste in your own sales data.

Sales Performance Dashboard

Revenue, orders and profit by month, region, sales rep and product category, with region and category filters.

  • 4 KPIs
  • 6 charts
  • 2 filters
View template
Campaign: AllChannel: AllMarketing Campaign DashboardTotal Spend$119.5KTotal of SpendTotal Clicks79,134Total of ClicksTotal Leads6,239Total of LeadsConversions Last 30 Days280▲ 18.1% vs previous 30 daysWeekly Leads by ChannelSearch AdsSocial AdsEmailDisplayApr 6Apr 27May 18Jun 8Jun 29Jul 20Aug 10Aug 31Sep 21Spend by ChannelSearch Ads48%Social Ads34%Display14%Email4%Clicks by ChannelSearch AdsEmailSocial AdsDisplayConversions by CampaignBrand SearchMonthly NewsletterOnboarding SeriesRetargetingCompetitor KeywordsSpring Product LaunchSummer AwarenessMonthly ImpressionsAprMayJunJulAugSepMonthly Spend by ChannelSearch AdsSocial AdsEmailDisplayAprMayJunJulAugSepWeekly Campaign ResultsWeekChannelCampaignImpressionsClicksSpendLeadsConversions2026-04-06Search AdsBrand Search9754649$951.5071182026-04-06Social AdsSpring Produ…60838657$1,607.123232026-04-06EmailMonthly News…14785461$87.963372026-04-13Search AdsBrand Search9128806$1,145.7884202026-04-13Social AdsSpring Produ…67447768$2,016.994162026-04-13EmailMonthly News…15588517$87.3436102026-04-20Search AdsBrand Search9534654$1,040.8784192026-04-20Social AdsSpring Produ…63522876$1,741.46568About this dashboardWeekly results for seven campaigns across search,social, email and display ads from April toSeptember 2026. The campaigns spent $119,497 andbrought in 6,239 leads and 1,453 conversions, withSearch Ads producing the most leads.•Use the Channel and Campaign filters at the top tonarrow every widget.•Switch to Sheets to edit the sample weeks or pastein an export from your ad platforms.

Marketing Campaign Dashboard

Weekly spend, clicks, leads and conversions for search, social, email and display campaigns, with channel and campaign filters.

  • 4 KPIs
  • 6 charts
  • 2 filters
View template
Expense Category: AllDepartment: AllBudget vs Actual DashboardTotal Budget$5.57MTotal of BudgetActual Spending$5.7MTotal of ActualBudget Variance-$132.7KTotal of VarianceBudget This Mo…$567K0% vs last monthSpending This…$581.8K▼ 2.6% vs last monthVariance This…-$14.8K▲ 51.6% vs last monthMonthly Actual SpendingJanFebMarAprMayJunJulAugSepOctSpending by Expense CategoryPayroll76%Software10%Facilities9%Travel5%Budget Variance by DepartmentSalesMarketingEngineeringOperationsFinance & AdminActual Spending by DepartmentPayrollSoftwareTravelFacilitiesEngineeringSalesOperationsMarketingFinance & AdminMonthly SpendingMonthDepartmentExpense CategoryBudgetActualVariance2026-01-01EngineeringPayroll$168,000$174,074.61-$6,074.612026-01-01EngineeringSoftware$21,000$23,869.15-$2,869.152026-01-01EngineeringTravel$4,000$3,845.60$154.402026-01-01EngineeringFacilities$12,000$12,293.37-$293.372026-01-01SalesPayroll$96,000$98,987.95-$2,987.952026-01-01SalesSoftware$9,000$10,007.69-$1,007.692026-01-01SalesTravel$14,000$13,704.62$295.382026-01-01SalesFacilities$7,000$6,961.38$38.62About this dashboardMonthly budget and actual spending for fivedepartments and four expense categories from Januaryto October 2026. Actual spending came to $5,703,749against a budget of $5,571,060, which is $132,689over budget. Variance is budget minus actual, so anegative number means the department spent more thanplanned. Sales has the largest overspend.•Use the Department and Expense Category filters atthe top to narrow every widget.•Switch to Sheets to edit the sample months orpaste in your own budget report.

Budget vs Actual Dashboard

Monthly budget and actual spending by department and expense category, with the variance that shows who is over or under budget.

  • 6 KPIs
  • 4 charts
  • 2 filters
View template
Channel: AllCampaign: AllNonprofit Fundraising DashboardTotal Raised$213.9KTotal of AmountRaised This Mo…$27,895▲ 1.4% vs last monthUnique Donors145Unique count of Donor…Average Gift$795.13Average of AmountNumber of Gifts269Count of Donor IDMonthly Donations by Donor TypeNewReturningJanFebMarAprMayJunJulAugSepOctAverage Gift by MonthJanFebMarAprMayJunJulAugSepOctProgress to Annual Goal$213.9KGoal $250KFunds Raised by CampaignMonthly GivingSummer Matching Chal…Spring AppealAnnual GalaBack to School DriveNumber of Gifts by ChannelOnlineMailEventMajor GiftDonations by ChannelMajor Gift73%Event14%Online8%Mail5%DonationsDonation DateDonor IDCampaignChannelDonor TypeAmount2026-01-01D-2127Monthly GivingOnlineNew$1002026-01-03D-2116Monthly GivingOnlineNew$1002026-01-04D-2109Monthly GivingMailNew$752026-01-05D-2025Monthly GivingOnlineNew$1002026-01-06D-2034Monthly GivingOnlineNew$1002026-01-07D-2034Monthly GivingMailReturning$1002026-01-08D-2006Monthly GivingMailNew$1002026-01-12D-2023Monthly GivingMajor GiftNew$14,250About this dashboard269 sample gifts from 145 donors between January andOctober 2026, raising $213,890 across fivecampaigns. Monthly Giving raised the most, and thegauge tracks progress toward a $250,000 annual goal.•Use the Campaign and Channel filters at the top tonarrow every widget.•Switch to Sheets to edit the sample gifts or pastein an export from your donor database.

Nonprofit Fundraising Dashboard

Donations by month, campaign, channel and donor type, with unique donors, average gift and progress toward an annual goal.

  • 5 KPIs
  • 6 charts
  • 2 filters
View template
Plan: AllRegion: AllCustomer Satisfaction DashboardResponses315Count of Response IDSatisfaction This Month3.79 / 5▼ 3.7% vs last monthLikelihood to Recommend6.78 / 10Average of Likelihood to RecommendMedian Resolution Hours3.6Median of Resolution HoursAverage Satisfaction by MonthJanFebMarAprMayJunJulAugSepOctResponses by Support ChannelLive Chat43%Email37%Phone20%Likelihood to Recommend by RegionNorth AmericaEuropeAsia PacificLatin AmericaAverage Satisfaction by Plan and ChannelPhoneEmailLive ChatProfessionalStarterEnterpriseAverage Resolution Hours by ChannelEmailPhoneLive ChatMonthly Responses by Support ChannelPhoneEmailLive ChatJanFebMarAprMayJunJulAugSepOctSurvey ResponsesResponse DateResponse IDRegionPlanSupport Chan…Satisfaction…Likelihood t…Resolution H…2026-01-04R-50001EuropeProfessionalPhone485.42026-01-04R-50002North AmericaStarterPhone471.52026-01-06R-50003North AmericaEnterprisePhone461.82026-01-09R-50004North AmericaEnterpriseEmail2436.62026-01-10R-50005EuropeProfessionalLive Chat370.72026-01-11R-50006North AmericaEnterprisePhone363.22026-01-14R-50007Latin AmericaProfessionalEmail3418.92026-01-14R-50008Latin AmericaStarterLive Chat361.2About this dashboard315 sample customer support survey responses fromJanuary to October 2026, across four regions, threeplans and three support channels. Each response hasa satisfaction score from 1 to 5, a likelihood torecommend from 0 to 10, and how many hours the issuetook to resolve. The average satisfaction score is3.68.•Use the Region and Plan filters at the top tonarrow every widget.•Switch to Sheets to edit the sample responses orpaste in an export from your survey tool.

Customer Satisfaction Dashboard

Support survey responses with satisfaction scores, likelihood to recommend and resolution times by month, region, plan and channel.

  • 4 KPIs
  • 6 charts
  • 2 filters
View template

Browse all dashboard templates.

Build your hr workforce dashboard today

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