June 29th, 2026
How to Create an Excel Dashboard: Complete Guide + Tips
By Tyler Shibata · 16 min read
An Excel dashboard turns a messy spreadsheet into a clear, visual snapshot of your key metrics. After building dozens of them for different business use cases, here's everything you need to know to make one that works.
What is an Excel dashboard?
An Excel dashboard is a single-page view in Microsoft Excel that displays your most important data as charts, tables, and key metrics. It pulls information from your raw data sheets and presents it in a format you can read at a glance, without having to scroll through hundreds of rows.
Most dashboards track things like sales performance, budget status, project progress, or marketing KPIs. You can build them using Excel's built-in tools, including PivotTables, PivotCharts, and slicers, and update them as your data changes.
Types of Excel dashboards
Excel dashboards can be built for almost any business function, but a few types come up most often. Here are some of the most common:
Sales dashboard: Tracks revenue, pipeline, conversion rates, and performance by rep or region so sales teams can spot trends and hit targets faster.
KPI dashboard: Displays your most critical business metrics in one view, giving managers and leadership a quick read on overall performance.
Financial dashboard: Monitors budgets, expenses, cash flow, and profitability, making it easier to catch overspending before it becomes a bigger problem.
Marketing dashboard: Pulls together campaign performance, traffic, leads, and ROI so you can see which channels are working and which aren't. I find this one particularly useful when reporting to stakeholders who want the headline numbers without the raw data.
Project management dashboard: Tracks task progress, deadlines, and resource allocation across a project, giving teams and stakeholders a shared view of where things stand.
How to create a dashboard in Excel: Step by step
Building an Excel dashboard takes more steps than most tutorials let on, but each one is straightforward once you know what you're working toward.
Here's how to do it from start to finish:
Step 1: Organize your data
Start by making sure your raw data is clean and structured. Each column needs a clear header, like "Date," "Revenue," or "Region," and each row should represent a single record with no blank rows or merged cells in between. If your data is messy at this stage, your charts and formulas likely will be too.
It helps to format your data as an Excel Table before you do anything else. Select your data range, then either go to Home and choose Format as Table or go to Insert and choose Table so Excel can treat it as a structured table.
Step 2: Set up your workbook sheets
Keep your raw data, chart data, and dashboard on separate sheets within the same workbook. I usually label them "Data," "Chart Data," and "Dashboard" to keep things clear. Your Data sheet holds everything you've imported or entered. Your Chart Data sheet is where you organize and summarize that data into a format ready for charting. Your Dashboard sheet is where the final output lives.
Keeping these separate makes it much easier to update your data later without accidentally breaking your charts or layout.
Step 3: Build your charts
With your data organized, you can start creating visuals. Highlight the data range you want to chart, go to Insert, and choose the chart type that fits your data best. Bar and column charts work well for comparing categories, line charts show trends over time, and pie charts can be useful for showing how parts make up a whole.
For more detailed analysis, PivotTables and PivotCharts are worth learning. A PivotTable summarizes large datasets just by dragging fields into rows, columns, and values. Once you've created a PivotTable, you can build a PivotChart directly from it by going to PivotTable Analyze and selecting PivotChart. These are useful if you plan to add interactive filtering later.
- 💡Tip: Give each chart a clear, descriptive title before you move on. It saves time when you're arranging everything on your dashboard sheet.
Step 4: Design your dashboard layout
Switch to your Dashboard sheet and start arranging your charts. Put your most important metrics at the top left, since that's where most people look first. Leave enough space between charts so the layout doesn't look crowded, and try to group related visuals together.
At this stage, I’d recommend sketching a rough layout before you start placing things. Moving charts around after you've connected slicers and formulas can get messy quickly.
Step 5: Format for consistency
A dashboard that uses 3 different fonts and 4 different shades of blue is harder to read than one that doesn't. Pick a consistent color palette, font, and number format and apply them across every chart and label. If you're tracking dollar amounts, make sure every relevant number uses the same format throughout.
Turn off gridlines and headings from the View tab once your layout is set. It makes the dashboard look much cleaner and keeps the focus on the data.
Step 6: Add interactivity
Slicers and dropdown menus let users filter the data they want to see without touching the underlying spreadsheet.
To add a slicer, click any PivotTable, then go to the PivotTable Analyze tab and select Insert Slicer, pick the fields you want, and click OK. You can then connect that slicer to multiple PivotTables by right-clicking it and choosing Report Connections.
To add a dropdown menu, click the cell where you want it, go to the Data tab, select Data Validation, and choose List under Allow, then type your list items or point to a cell range. From there, use formulas like FILTER, XLOOKUP, or IF in a helper range that your charts point to, so changing the dropdown changes the data your charts use.
💡Tip: Make sure your PivotTables have enough space to expand when filters are applied. If 2 PivotTables try to occupy the same space, Excel will throw an error.
Step 7: Review and test
Before you share anything, test every filter and slicer to check that your charts respond the way you expect. Click through different combinations and make sure nothing breaks or overlaps. It's also worth checking that your data source is still connected and that all your numbers match what's in your raw data sheet.
I usually run through the dashboard as if I were a stakeholder seeing it for the first time. If something takes more than a few seconds to understand, it probably needs a clearer label or a simpler layout.
Step 8: Share your dashboard
Once your dashboard is ready, you can share it a few different ways. The simplest option is to save the workbook to a shared location like OneDrive or SharePoint and send the link. Anyone with access can open the latest version without you having to email a file back and forth.
If your team uses a Microsoft 365 group, you can pin the workbook to the top of the group’s SharePoint document library so it’s easy to find. Go to the group’s SharePoint site, open Documents, select the file, and choose Pin to top so it always shows at the top of the library. From that point, everyone in the group can access the most current version from one place.
For users who don't need to edit the file, you can also export the dashboard as a PDF or share individual charts as images directly from Excel.
Best practices for effective Excel dashboards
Building the dashboard is only half the job. These practices help make sure it stays useful once it's in people's hands:
Keep it focused: Only include the metrics that matter for the dashboard's purpose. It's tempting to add everything you track, but a cluttered dashboard is harder to read than a simple one. I’d aim for 5 to 7 key metrics per view.
Use consistent formatting: Stick to the same fonts, colors, and number formats throughout. Inconsistent styling makes a dashboard look unfinished and can confuse readers who are trying to compare numbers across charts.
Label everything clearly: Every chart, table, and metric should have a title that tells the reader exactly what they're looking at. I've seen dashboards with beautiful visuals that nobody could interpret because the labels were missing or too vague.
Add filters so users can explore the data: Slicers and dropdowns let people drill into the data that's relevant to them without editing the underlying spreadsheet. This is especially useful when multiple teams or stakeholders are using the same dashboard.
Update your data regularly: A dashboard built on stale data can lead to bad decisions. Set a schedule for refreshing your data, whether that's daily, weekly, or monthly, and stick to it.
Limitations of Excel dashboards
Excel dashboards work well for a lot of use cases, but they do have limits worth knowing before you invest time building one.
Here’s what to look out for:
Performance slows down with large datasets: Excel can struggle when you're working with tens of thousands of rows or more. Dashboards built on large data files can take a long time to load, refresh, or respond to filter changes, which makes them frustrating to use in practice. I've hit this wall more than once when pulling in a full year of transaction-level data.
Data doesn't update on its own: Unless you set up an external data connection, your dashboard will only reflect the data you've manually entered or refreshed. If your numbers change frequently, you'll need to remember to update the source data every time, which is easy to forget.
Collaboration is limited: Excel isn't built for real-time teamwork. If multiple people are working on the same file at once, you can run into version conflicts, overwritten changes, or slow load times. Sharing via OneDrive helps, but it still doesn't match the live collaboration you'd get from a dedicated reporting tool.
Visualization options are basic: Excel covers the standard chart types well enough, but it can fall short for more complex or interactive visuals. If you need dynamic maps, advanced drill-downs, or highly customized charts, you'll likely hit a ceiling fairly quickly. In my experience, this is where most business users start looking for something more.
Scaling gets difficult: As your dashboard grows, the file can become harder to manage. More data, more sheets, and more formulas add up, and what started as a clean, simple file can turn into something difficult to maintain or hand off to someone else.
