How to Build an Excel Dashboard

How to use it

1. Decide the questions. List three to six measures your reader needs, such as revenue, profit margin, units and top region.
2. Keep three layers. Use one sheet for raw data, one for calculations and one for the dashboard. Never type over the data sheet.
3. Turn the data into a Table with Ctrl+T so formulas and charts grow automatically when you add rows.
4. Calculate each measure with formulas or a PivotTable, then link the dashboard cells to those results.
5. Add charts. Pick the simplest chart that fits: column or bar for comparing groups, line for change over time.
6. Add slicers to let readers filter by region, product or month with one click.
7. Tidy the layout. Hide gridlines, align shapes, and put the most important number at the top left.

Formulas that power most dashboards

These formulas do most of the work. The ranges assume a Table or data in columns A to F.

=SUM(Data[Revenue])
=SUMIFS(Data[Revenue], Data[Region], "North")
=SUMIFS(Data[Revenue], Data[Date], ">="&DATE(2026,4,1), Data[Date], "<"&DATE(2026,5,1))
=IFERROR(Profit/Revenue, 0)

See our guides to SUMIFS, IFERROR and SUM for the details.

Design rules that keep it readable

• Use one or two colors and use them consistently, for example green for good and red for bad.
• Label every chart with a plain title that states what it shows.
• Avoid 3D charts and pie charts with many slices.
• Use Conditional Formatting for icons, data bars or color scales on key numbers.
• Put the date of the last refresh on the sheet.

Refreshing the dashboard

If you use PivotTables, right-click and choose Refresh, or use Data > Refresh All, after adding data. Formulas update automatically. Test the dashboard with a few new rows to be sure nothing is hard-coded.

Start from a working file

Our free Excel dashboard template includes a data sheet, KPI cells, summary tables and two charts, all driven by formulas. Replace the sample rows with yours.