How to Make a Dashboard in Excel (Beginner Guide)

To make a dashboard in Excel, put your data in a Table, build pivot tables and charts from it, arrange them on a fresh sheet, and add slicers for one-click filtering. That turns a wall of rows into a summary anyone can read. It sounds advanced, but you can build a solid one in about 30 minutes.

What a dashboard actually is

A dashboard is a single screen that answers the main questions about your data: totals, trends, and a breakdown. It doesn’t hold data — it summarises other sheets.

You need:

• One table of raw data (sales, expenses, tasks — anything with categories and numbers)
• A few pivot tables to summarise it
• Charts built from those pivots
• Slicers so the viewer can filter without touching formulas

Step 1: Turn your data into a Table

1. Click any cell in your data.
2. Press Ctrl + T and confirm the range has headers.
3. Give the table a name in Table Design → Table Name (e.g. SalesData).

Tables auto-expand as you add rows, so your dashboard never goes stale.

Step 2: Build the pivot tables

1. Click inside the table.
2. Go to Insert → PivotTable → New Worksheet.
3. Drag fields into the four areas:
   • Rows — the thing you’re grouping by (Region, Month, Category)
   • Values — the number to add up (Sum of Sales)
   • Columns — optional second grouping
4. Build two or three of these — one per question you want to answer.

Step 3: Add charts

1. Click inside a pivot table.
2. Go to Insert and pick a chart — Column for comparisons, Line for trends, Pie for shares.
3. Repeat for each pivot.

Charts built on a pivot refresh automatically when the data changes — see how to make a graph in Excel if you’re new to charts.

Step 4: Arrange it and add slicers

1. Insert a new sheet and name it Dashboard.
2. Cut and paste your charts onto it; line them up with the alignment guides.
3. Click a chart or pivot → PivotTable Analyze → Insert Slicer.
4. Tick the field you want to filter by (e.g. Region).
5. Right-click each slicer → Report Connections to have one slicer drive every pivot.

Now clicking “North” filters the whole dashboard at once — that interactivity is what makes it feel real.

Step 5: Make it readable

• One idea per chart. Don’t cram four series into one.
• Kill the clutter. Delete gridlines, axis lines, and legends you don’t need.
• Big numbers up top. Add a few large cells using =SUM(...) for headline totals.
• Consistent colours. One colour per category, everywhere.
• Space it out. Gaps between charts read better than a packed grid.

Keep it working

• Refresh with Ctrl + Alt + F5 after the source data changes.
• Add rows to the table (not below it) so pivots pick them up.
• Save a copy before big changes — pivots are easy to break, hard to unbreak.

FAQ

What do I need to build an Excel dashboard?

One clean data table, two or three pivot tables, charts from those pivots, and slicers for filtering. No add-ins or coding.

Is an Excel dashboard hard to make?

The mechanics are beginner-friendly — mostly drag-and-drop in pivot tables. The skill is deciding which numbers matter, not the Excel part.

How do I make my dashboard interactive?

Add a slicer (PivotTable Analyze → Insert Slicer), then use Report Connections so one slicer controls every pivot table on the sheet.

Does an Excel dashboard update automatically?

Not by itself — press Ctrl + Alt + F5 to refresh. If your data lives in a Table, new rows flow in on refresh.

What’s the difference between a dashboard and a pivot table?

A pivot table is one summary. A dashboard arranges several pivots and charts on one sheet so the whole picture is visible at once. See how to use a pivot table in Excel for the building block.