How to make a dashboard in Excel
A good Excel dashboard turns rows of data into a page of answers — KPIs, trends and breakdowns a manager can read at a glance. Here’s how to build one from scratch, the layout choices that make it usable, and the fast way to get a live dashboard automatically.
The build, step by step
A dashboard is a layout on top of clean, summarised data.
Start with the data on its own sheet, as a clean table (one header row, consistent types, no blanks). Everything downstream depends on this. Then build the summaries: one PivotTable per number you want to show — revenue by month, sales by region, top products — on a working sheet you’ll hide later.
Turn each PivotTable into a PivotChart (bar for comparisons, line for trends, a single big number for a headline KPI). Add slicers — clickable filters for date or category — and connect them to multiple charts so one click filters the whole dashboard. Slicers are what make it feel interactive rather than static.
Finally, create a Dashboard sheet and arrange the charts and KPI cards on a grid: headline numbers across the top, trends and breakdowns below. Hide the working sheets, lock the layout, and you have a dashboard. The catch: it’s a snapshot — you must Refresh when the data changes.
What goes on a dashboard
The building blocks and when to use each.
| Element | Best for | How |
|---|---|---|
| KPI cards | Headline numbers (revenue, orders) | Big cell or a 1-value PivotTable |
| Bar / column chart | Comparing categories | PivotChart from a category pivot |
| Line chart | Trends over time | PivotChart from a date pivot |
| Slicers | Interactive filtering | Insert → Slicer, connect to pivots |
| Conditional formatting | Highlighting good/bad | Colour scales, data bars |
The layout mistakes to avoid
A cluttered dashboard is worse than a table.
The commonest mistake is putting everything on the dashboard. A dashboard answers a few important questions, not all of them — pick the five metrics that matter and cut the rest. The second is inconsistent formatting: mixed colours, different date formats, charts at different scales make it hard to read at a glance.
Follow a simple grid: the most important number top-left (that’s where the eye lands first), supporting trends and breakdowns below, filters in a consistent place. White space is your friend — a clean dashboard with five clear metrics beats a busy one with twenty.
The fast way: a live dashboard automatically
Skip the PivotTables and get a dashboard from your file.
Building an Excel dashboard by hand is a real afternoon: pivots, charts, slicers, layout, and a manual Refresh every time the data changes. DataHub Pro does it in about two minutes. Upload the spreadsheet and it detects your metrics and categories, builds the KPI cards, trend lines and breakdowns automatically, and lays them out as an interactive dashboard — no PivotTables, no manual refresh.
When next month’s data arrives, you re-upload and the dashboard updates itself. You can share it as a live link, or export it as a branded report. For a recurring dashboard, that turns an afternoon into a two-minute job. Try it on your own file and compare.
Frequently asked questions
How do I make a dashboard in Excel?
Put your data on a clean sheet as a table, build one PivotTable per metric, turn each into a PivotChart, add slicers as interactive filters, then arrange the charts and KPI cards on a dedicated Dashboard sheet. Refresh the pivots when the data changes. For a live dashboard without the manual work, upload the file to DataHub Pro.
What makes a good Excel dashboard?
Focus: five clear metrics beat twenty cluttered ones. Put the most important number top-left, keep formatting and chart scales consistent, use slicers for interactivity, and leave white space. A dashboard answers a few important questions at a glance, not every question.
How do I make an Excel dashboard interactive?
Add slicers (Insert → Slicer) and connect them to multiple PivotTables/PivotCharts so one click filters the whole dashboard. Timelines work the same way for dates. Tools like DataHub Pro make dashboards interactive automatically.
Do Excel dashboards update automatically?
No — PivotTable-based dashboards are snapshots and need a manual Refresh (or refresh-on-open) when the source data changes. A spreadsheet-native tool like DataHub Pro rebuilds the dashboard automatically when you upload new data.
Is there an easier way to build a dashboard than Excel?
Yes. Upload your spreadsheet to DataHub Pro and it auto-builds an interactive dashboard — KPI cards, trends and breakdowns — in about two minutes, with no PivotTables or manual refresh, and you can share it as a live link or branded report.
How long does it take to build an Excel dashboard?
By hand, a first dashboard often takes an afternoon (pivots, charts, slicers, layout), then ongoing maintenance each period. Automatically, from an uploaded file, it takes about two minutes and updates itself on re-upload.
Explore related guides
More dashboard and Excel guides.
Turn your spreadsheet into a live dashboard
Upload a file and DataHub Pro builds an interactive dashboard automatically — KPI cards, trends and breakdowns, no PivotTables. Share it live or export a branded report. Free tier, then $14.99/mo.
Try it free on your file →