How to Create a Recruitment Dashboard in Excel

Building a recruitment dashboard in Excel transforms messy hiring data into a clear story, helping you track critical metrics and make smarter hiring decisions at a glance. Instead of digging through spreadsheets, you can have a centralized, visual command center for your entire hiring pipeline. This guide will walk you through creating a dynamic and interactive recruitment dashboard in Excel from scratch, step-by-step.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

First, Organize Your Recruitment Data

A great dashboard is built on a foundation of clean, structured data. Before you build any charts, you need a single source of truth for all your recruitment activities. The best way to do this in Excel is to create a simple, flat table with all your application information.

Create a sheet in Excel named "Recruitment Data" and set it up with the following columns. Each row will represent one candidate application.

• Candidate ID: A unique identifier for each candidate.
• Candidate Name: The full name of the candidate.
• Position: The role they applied for.
• Department: The department of the open position.
• Application Source: Where the candidate came from (e.g., LinkedIn, Indeed, Employee Referral, Company Website).
• Application Date: The date the application was submitted.
• Current Stage: The candidate’s current status in the pipeline (e.g., Applied, Phone Screen, Interview 1, Interview 2, Offer Extended, Hired, Rejected).
• Hired Date: The date the candidate was officially hired.
• Application Closed Date: The date the application was closed (either hired or rejected).
• Hiring Manager: The name of the manager responsible for a decision on this role.

Your goal is to have a simple, raw data log. Avoid summary columns, merged cells, or complicated formatting. Just a straightforward table with clear headers and consistent data entry.

Format Your Data as an Official Excel Table

Once you have your raw data organized, your next step is to convert it into an official Excel Table. This is an incredibly useful feature that makes your data dynamic, meaning any charts and formulas connected to it will update automatically when you add new rows (like new candidates).

Here’s how to do it:

1. Click anywhere inside your data set.
2. Go to the Insert tab on the Excel ribbon.
3. Click on the Table button.
4. A small box will pop up. Make sure the option "My table has headers" is checked.
5. Click OK.

Your data will now be formatted with alternating colored rows. You can change this style in the Table Design tab that appears. More importantly, Excel now recognizes this range as a unified data source, which is the key to building our dashboard.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Calculate Your Key Recruitment KPIs

Before visualizing, we need to calculate some key performance indicators (KPIs) that tell us how our recruitment process is performing. We can add these as new "helper columns" to our Excel Table. Since it's a Table, the formulas will automatically copy down to every row for you.

Calculating 'Time to Fill'

"Time to fill" (or "time to hire") is one of the most important recruitment metrics. It tells you how long it takes to move from an application date to a hired date.

1. Go to your data Table and add a new column header called "Time to Fill (Days)".
2. In the first cell of that column, enter the following formula. Let's assume your "Hired Date" column is H and "Application Date" is F.

=[@[Hired Date]]-[@[Application Date]]

This formula subtracts the application date from the hired date to give you the number of days. If a candidate hasn’t been hired yet, the cell will show an error or a strange number. We can clean this up with an IFERROR formula so it only shows a value if the candidate is hired.

=IFERROR([@[Hired Date]]-[@[Application Date]],"")

Calculating 'Application Age'

Application age tells you how long a current application has been open. This helps you spot bottlenecks where candidates might be getting stuck in your pipeline.

1. Add a new column header called "Application Age (Days)".
2. Enter this formula, which calculates the days between the application date and today - but only for applications that are not yet closed.

=IF(AND([@[Current Stage]]<>"Hired", [@[Current Stage]]<>"Rejected"), TODAY()-[@[Application Date]], "")

Now you have the core calculated data you need to build the visualizations for your dashboard.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Build the Dashboard Using Pivot Tables and Pivot Charts

This is where the magic happens. We will use Pivot Tables to summarize our raw data and Pivot Charts to visualize those summaries. The best practice is to keep your Pivot Tables on one sheet and your final dashboard on another.

Create two new tabs in your Excel file: one named "Dashboard" and another named "Calculations".

To create your first Pivot Table:

1. Go back to your "Recruitment Data" sheet and click anywhere inside your data Table.
2. Go to Insert > PivotTable.
3. In the dialog box, make sure your table is selected and choose Existing Worksheet for where to place it.
4. Click the location box, then navigate to your "Calculations" sheet and select cell A1. Click OK.

You now have a blank PivotTable ready to go. We'll repeat this process for each visualization we need.

Visualization 1: The Hiring Funnel

The hiring funnel shows you how many candidates are in each stage of the pipeline.

1. Create a Pivot Table in your "Calculations" sheet.
2. Drag "Current Stage" into the Rows area of the PivotTable Fields pane.
3. Drag "Candidate ID" into the Values area. Make sure it's set to "Count of Candidate ID".
4. With the PivotTable selected, go to PivotTable Analyze > PivotChart.
5. Choose a Bar Chart or Funnel Chart and click OK.
6. Cut this chart (Ctrl+X or Cmd+X) and paste it (Ctrl+V or Cmd+V) onto your "Dashboard" sheet.
7. Clean up the chart: Right-click the grey field buttons on the chart (like "Count of Candidate ID") and choose "Hide all field buttons on chart". Add a clear title.

Visualization 2: Applicants by Source

This chart answers the question: "Where are our candidates coming from?"

1. Create a second Pivot Table on your "Calculations" sheet.
2. Drag "Application Source" into the Rows area.
3. Drag "Candidate ID" into the Values area (set to Count).
4. Create a PivotChart from this table. A Pie Chart or Doughnut Chart works well here.
5. Cut and Paste the chart onto your dashboard and clean it up.

Visualization 3: Average Time to Fill

Dashboards need high-level KPIs. Instead of a chart, we’ll create a KPI card.

1. Create a new Pivot Table on the "Calculations" sheet.
2. Drag your "Time to Fill (Days)" helper column into the Values area.
3. By default, it will probably Sum the values. Click on it, choose Value Field Settings, and switch it to Average.
4. Now, go to your "Dashboard" tab. Click a cell where you want your KPI.
5. Type = and then navigate to your "Calculations" sheet and click the cell with the average value in your Pivot Table. Press Enter.
6. Increase the font size of this cell dramatically. Add a text box or shape behind it to make it stand out as a key number.

Repeat this KPI card process for other key metrics, like counting the "Total Open Roles" or "Total Candidates".

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Make Your Dashboard Interactive with Slicers

A static dashboard is useful, but an interactive one is a game-changer. Slicers are user-friendly buttons that filter your data, allowing anyone to drill down and explore specific views.

1. On your "Dashboard" tab, click on any one of your charts to select it.
2. Go to the PivotChart Analyze tab on the ribbon.
3. Click Insert Slicer. A dialog box will appear with all your data columns.
4. Check the boxes for fields you want to filter by - common choices are "Department", "Hiring Manager", and "Position". Click OK.

You will now see slicer boxes appear on your dashboard. You can rearrange them and resize them. You’ll notice when you click a button in a slicer, only the chart you originally selected will update. We need to connect them to all your dashboard elements.

Connecting Slicers to All Charts

This is the most important final step for interactivity.

1. Right-click on the first slicer (e.g., "Department").
2. Select Report Connections.
3. In the dialog box, you'll see a list of all your PivotTables in your workbook. Check all the appropriate boxes to link the slicer to every PivotTable powering your dashboard.
4. Click OK.
5. Repeat this process for every slicer on your dashboard.

Now, when you click on a Department, Hiring Manager, or Position in any slicer, your entire dashboard - KPIs and charts - will instantly update to reflect that filter. You've just built a fully dynamic recruitment reporting tool!

Final Thoughts

You have successfully moved from a raw list of candidate data to a dynamic, interactive dashboard in Excel. By organizing your data in a Table, calculating helper metrics, summarizing with Pivot Tables, and visualizing with Pivot Charts and Slicers, you've created a powerful tool to track your hiring process and share data-driven insights with your team.

While Excel gives you a ton of control, it does require manual setup and a few clicks every time you need to refresh your data. At Graphed, we sought to simplify this process. You can connect your HR information systems (or even just an updating Google Sheet) and use natural language to ask for exactly what you need - like "show me a hiring funnel dashboard grouped by department for this quarter." We instantly build a live, interactive dashboard that's always up-to-date, letting you spend your time on insights instead of manual reporting.