How to build an Excel dashboard
step by step

What makes a good Excel dashboard

A good dashboard answers specific questions at a glance without requiring the viewer to do any analysis. It has a clear purpose (sales performance, HR headcount, financial summary), shows the right level of detail, and updates automatically when data changes.

Step 1 — Structure your source data properly

Convert your data to an Excel Table (Ctrl+T). Give it a meaningful name like "SalesData". All your pivot tables and charts will connect to this table and update automatically when new rows are added.

Step 2 — Build pivot tables for each metric

Insert → PivotTable → use your Table as the source. Build one pivot table per key metric on a separate "Data" sheet — don't put pivot tables directly on the dashboard. Common metrics:

• Total sales by region (Rows: Region, Values: Sum of Sales)
• Monthly trend (Rows: Month, Values: Sum of Sales)
• Top 10 products (Rows: Product, Values: Sum of Revenue, filter top 10)

Step 3 — Build charts from the pivot tables

Click inside a pivot table → Insert → chart of your choice. Move the chart to the dashboard sheet. The chart stays connected to the pivot table and updates when data changes.

Step 4 — Add KPI cards

Simple cells formatted with large fonts showing key numbers — total revenue, number of customers, average order value. Use GETPIVOTDATA to pull numbers from pivot tables:

Step 5 — Add slicers for interactivity

Click any pivot table → PivotTable Analyze → Insert Slicer → choose a field (Region, Month, Product). Connect the slicer to all pivot tables: right-click the slicer → Report Connections → check all pivot tables. Now clicking a slicer button filters every chart and metric simultaneously.