How to Build a Business Dashboard in Excel (Step by Step)

A business dashboard in Excel is a single sheet — usually the first tab in the workbook — that shows a handful of KPIs, a few PivotCharts, and one or two slicers, all built from a raw-data table kept on a separate sheet. No add-ins are required: PivotTables, PivotCharts, slicers, and conditional formatting all ship with Excel.

This is the general framework. If you want the version tailored to a specific team, see the sales, marketing, finance, operations, startup, and agency-reporting walkthroughs linked at the end.

Start with one clean data table, not the report itself

The most common reason an Excel dashboard breaks is that it was built directly on top of a messy export — merged cells, subtotal rows, inconsistent date formats. Before touching a chart:

1. Paste the raw export onto its own sheet, named something like Data.
2. Convert it to a proper Excel Table (Ctrl+T). This gives every column a name, and any PivotTable built from it will automatically pick up new rows when the table grows.
3. Remove subtotal or blank rows the export software added — a PivotTable will double-count them otherwise.
4. Fix column types: dates as dates, numbers as numbers, not text. Data > Text to Columns fixes most cases in one pass.

Pick 4-6 KPIs, not twenty

A dashboard that shows everything shows nothing. Pick the numbers someone would actually ask about in a weekly check-in — for most teams that’s 4 to 6 figures, each with a comparison (vs. last period, vs. target).

Lay these out as a row of cells at the top of the dashboard sheet, each one a simple formula referencing a PivotTable value (=GETPIVOTDATA(...) or a plain cell reference) — not hardcoded numbers, so they update when the underlying data refreshes.

Build the PivotTables and PivotCharts

On the dashboard sheet:

1. Insert > PivotTable, source = your Data table, and place it on a new sheet per breakdown (by region, by category, by month).
2. Build a PivotChart from each PivotTable (PivotChart button on the PivotTable Analyze tab) rather than a plain chart — PivotCharts stay linked to the PivotTable and update together.
3. Copy each PivotChart onto the dashboard sheet as a linked picture (Copy > Paste Special > Linked Picture) if you want a clean layout with no visible PivotTable grid — the chart stays live, but the underlying table stays out of sight.

Add slicers for the filters people actually use

Insert a slicer (Insert > Slicer) for the 1-2 dimensions people will realistically want to filter by — date range and category or region are the usual pair. Connect the same slicer to every PivotTable on the dashboard (Report Connections on the slicer’s ribbon tab) so one click filters every chart at once, not just one.

Excel dashboard vs. a live, shareable one

Excel is the right tool when the dashboard is built once, by one person, for a small audience already comfortable opening a workbook. It gets harder once several people need to edit it, the data updates weekly, or someone downstream just wants an answer without opening Excel at all.

If you’re at that point, see how teams turn a recurring export into a shareable dashboard instead of a workbook.