How to Create a Project Management Dashboard in Excel That Actually Helps You Manage Projects

I've built and worked with many Excel reporting tools, and one thing I've learned is that a dashboard doesn't become useful simply because it has charts.

A good project management dashboard should help you answer important questions quickly:

What's on track? What's overdue? What needs attention? Who owns it? And where should I focus next?

That's the real purpose of a dashboard.

In this guide, I'll walk you through how I approach building a project management dashboard in Excel—from organizing the source data to choosing KPIs, adding visuals and creating a dashboard that can actually help you manage the work.

1. Start With the Questions, Not the Charts

One of the easiest mistakes to make when creating a dashboard is starting with the design.

It's tempting to open Excel, insert a few charts and start choosing colours.

I recommend doing the opposite.

Before building anything, ask yourself:

• How many projects are currently active?

• Which projects are overdue?

• Which projects need attention?

• What are the highest-priority projects?

• What actions are coming due?

• Are projects progressing as expected?

• Where are the major risks or issues?

Your dashboard should be designed around answering those questions.

If a chart doesn't help you understand something or make a decision, ask whether you really need it.

A dashboard should make your project information easier to understand—not simply make your spreadsheet look better.

2. Build a Clean Project Data Table

Before creating the dashboard, you need reliable source data.

A basic project table might contain:

Project Owner Status Priority Start Date Deadline % Complete

Website Redesign Sarah In Progress High Aug. 1 Sept. 30 65%

Training Program Michael Planned Medium Sept. 1 Nov. 15 10%

System Upgrade David In Progress High July 15 Sept. 15 80%

The exact columns will depend on your projects, but consistency matters.

Each column should represent one type of information and each row should represent one project or record.

Microsoft recommends properly structured source data for Excel dashboards, including avoiding missing rows or columns and organizing individual records consistently. Formatting the source data as an Excel Table also makes it easier to work with expanding datasets.

This is something I pay close attention to when building Excel tools.

A beautiful dashboard sitting on top of poorly structured data will eventually create problems.

Build the data correctly first. Then build the reporting.

3. Choose KPIs That Tell You Something Useful

The top of your dashboard is valuable space.

Don't fill it with numbers just because you can.

For a project management dashboard, I often start with a small number of useful KPIs such as:

• Total Projects How much work are you currently managing?

• In Progress How many projects are actively underway?

• Completed How many have been delivered?

• Overdue How many projects have passed their target date without being completed?

• Average Completion What does overall project progress look like?

You don't necessarily need all five.

Choose the KPIs that help you understand the health of your particular portfolio.

The goal is that someone can look at the top of the dashboard and understand the overall situation within seconds.

4. Show Project Status Visually

Once you know how many projects you have, the next question is usually:

Where do they stand?

You might use categories such as:

• Planned

• In Progress

• Completed

• On Hold

• At Risk

A PivotTable can summarize the number of projects in each category, and a PivotChart can turn that summary into a visual.

Excel PivotTables are designed to calculate, summarize and analyze data, which makes them particularly useful when your project tracker contains many records.

For example:

12 In Progress
6 Completed
3 Planned
2 On Hold

Now the project manager doesn't have to manually count rows every time the tracker changes.

5. Don't Just Show Progress—Show What Needs Attention

This is where I think project dashboards can become much more useful.

A dashboard shouldn't only tell you what's going well.

It should help you identify where you need to look.

Consider displaying:

• High-Priority Projects

• Overdue Projects

• Open Risks

• Outstanding Actions

• Projects Approaching Their Deadline

If you have 20 active projects but only three require immediate attention, your dashboard should help you find those three quickly.

That's much more useful than simply knowing you have 20 projects.

6. Bring Upcoming Actions Onto the Dashboard

One of my favourite things to include in a project dashboard is an Upcoming Actions section.

Project managers often have action items sitting on another worksheet—or worse, spread across meeting notes and emails.

Instead, bring the most important upcoming actions directly onto the dashboard.

For example:

Action Owner Due Date Priority

Confirm project requirements Sarah Aug. 15 High

Obtain stakeholder approval Michael Aug. 18 High

Finalize training materials David Aug. 22 Medium

Now when you open the dashboard, you immediately know what's coming next.

This is particularly useful before project meetings because you don't have to search through several tabs to determine what needs follow-up.

7. Include Risk Visibility

Projects don't become risky only after they miss a deadline.

That's why I like connecting risk information to the overall project view.

Your detailed RAID log can remain on its own worksheet, but the dashboard can surface information such as:

• Open High Risks

• Critical Issues

• Overdue Mitigation Actions

• Projects With Active Risks

You don't need to reproduce the entire RAID log on the dashboard.

The dashboard's job is to tell you:

There's something here you need to investigate.

Then you can go to the detailed RAID log when necessary.

8. Add a Timeline or Gantt View

Project lists are useful, but dates become much easier to understand when you can see them visually.

A Gantt chart can help show:

• Project start dates

• Finish dates

• Duration

• Overlapping activities

• Key milestones

• Progress against the timeline

I don't recommend squeezing a massive Gantt chart onto the main dashboard.

Instead, use the dashboard for high-level timeline information and keep the detailed Gantt view on a dedicated worksheet.

That gives you both:

At-a-glance reporting and detailed project planning.

9. Add Filters That Actually Help

Once you have multiple projects, filters become very useful.

For example, you might want to see:

• Project Manager

• Status

• Priority

• Department or Region

• Project Type

Excel slicers provide clickable buttons that filter Tables and PivotTables, and they also show which filters are currently applied.

That makes them especially useful for interactive dashboards.

But don't add ten slicers simply because Excel allows it.

Ask: What would someone realistically want to filter during a project review?

Add those.

10. Keep the Dashboard Easy to Read

More information does not automatically create a better dashboard.

I prefer:

• Clear KPI cards

• A few useful charts

• Consistent status colours

• Enough white space

• Short labels

• Logical sections

And most importantly:

Make important information stand out.

If everything on the dashboard is bold, colourful and competing for attention, nothing really stands out.

For example, if an overdue project requires attention, it should be easier to notice than a project that is progressing normally.

11. Make the Dashboard Refreshable

One of the biggest benefits of structuring the workbook correctly is that you shouldn't have to rebuild your dashboard every reporting cycle.

Excel dashboards can be created using PivotTables, Pivot Charts and shared slicers connected to the same underlying data. When the source information is updated, the reporting can then be refreshed.

That means your workflow becomes:

Update the project data → Refresh → Review the dashboard

instead of:

Update data → manually recount everything → rebuild charts → prepare another report.

That difference can save a lot of repetitive reporting work.

12. Test Your Dashboard Like a Project Manager

Before you consider the dashboard finished, stop thinking like the person who built it.

Pretend you're opening it for the first time.

Can you answer these questions quickly?

• How many projects are active?

• Which projects are overdue?

• What requires attention?

• What's coming due next?

• Where are the risks?

• Who owns the work?

• Are we progressing as expected?

If you can't answer those questions without searching through the workbook, there may still be an opportunity to simplify or improve the dashboard.

I use this approach because a dashboard isn't just a reporting tool.

It's a decision-support tool.

Common Excel Project Dashboard Mistakes

Here are a few mistakes I would avoid.

Too Many Charts

You don't need a chart for every data point.

Too Many Colours

Use colour intentionally. Status and priority should mean something.

Poor Source Data

If the underlying tracker isn't structured consistently, the dashboard won't be reliable.

Showing Everything

Detailed project information belongs in your trackers. The dashboard should summarize what's important.

No Clear Attention Areas

Don't make the project manager search for problems. Surface them.

Manual Reporting

If you're repeatedly typing numbers into dashboard cards that already exist somewhere else in the workbook, look for an opportunity to automate that connection.

What a Good Project Management Dashboard Should Give You

At its best, your dashboard should give you three things:

Visibility

You can see what's happening.

Focus

You can identify what needs attention.

Confidence

You know the information is coming from a structured project-management process.

That's much more important than how many charts you can fit onto one worksheet.

Don't Want to Build Everything From Scratch?

Building a complete project management workbook can take time—especially when you're connecting project tracking, action items, risks, timelines and reporting.

That's one of the reasons I built the Excel PMO Pro Toolkit.

It brings together:

• Project tracking

• Action item management

• RAID tracking

• Gantt planning

• Project dashboards

• Project status reporting

within one Excel-based project management system.

Instead of maintaining separate spreadsheets, you can keep the major parts of project management connected within one workbook.

Explore the Excel PMO Pro Toolkit

Final Thoughts

• You don't need the most complicated Excel dashboard.

• You need one that helps you understand your projects.

• Start with clean data.

• Choose the questions you need answered.

• Build KPIs around those questions.

• Add visuals where they genuinely make the information easier to understand.

• And always make sure the dashboard helps you identify what requires attention—not just what has already happened.

When I build a project dashboard, that's the standard I try to come back to:

Can I understand where my projects stand at a glance?

If the answer is yes, the dashboard is doing its job.

Related Guide

If you're building your project management system from the beginning, read:

Free Excel Project Management Template: How to Track Projects, Tasks & Deadlines

Sources Microsoft — Create and share a dashboard with Excel

Microsoft — Use slicers to filter data