In Excel: split the workbook into three sheets — raw Data, a PivotTable Calc layer, and a Dashboard sheet holding only charts and slicers — then connect the slicers to every PivotTable with Report Connections.
Put the raw data on its own sheet and press Ctrl+T to make it a Table, so new rows are picked up automatically.
Build the summaries as PivotTables on a separate Calc sheet — never on the sheet the reader sees.
On the Dashboard sheet, insert PivotCharts pointing at those PivotTables and arrange them on a grid.
Add three to five headline numbers as large, formatted cells; a dashboard people read at a glance needs a top line.
Insert slicers or a timeline, then right-click each ▸ Report Connections and tick every PivotTable it should filter.
Untick View ▸ Gridlines and View ▸ Headings, and set the print/zoom so everything fits one screen without horizontal scrolling.
Refresh with Data ▸ Refresh All; consider Analyze ▸ PivotTable Options ▸ Refresh data when opening the file.
What this does
A dashboard is a layout discipline, not a feature. The structure that survives contact with real data is three sheets. Data holds the raw rows as an Excel Table so ranges grow by themselves. Calc holds the PivotTables and helper formulas that summarise it. Dashboard holds only the output — charts, a few large number tiles, and slicers or timelines for filtering — with gridlines hidden and nothing the reader has to scroll sideways to see. Slicers are what make it interactive: insert one from any PivotTable, then right-click ▸ Report Connections and tick every PivotTable it should drive, so one click filters the whole page. Keep the inputs visible and clearly labelled and the whole thing stays auditable — anyone who opens the file later, including you, can see at a glance exactly what feeds the result and change one assumption without hunting through the formula. The difference between a quick fix and a sheet you can trust is the extra minute you spend validating “excel dashboard templates free”. Start on a copy or a tiny sample, keep the affected cells visible, and compare the result with the tool above before you touch the real workbook. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. The point is a visual that makes the number obvious at a glance, but the practical win is that someone else can open the file and understand what happened without asking you.
A worked example
Sales rows on a Data sheet formatted as a Table named tblSales. On Calc, three PivotTables from tblSales: revenue by month, revenue by region, top 10 products. On Dashboard, a PivotChart for each, plus =GETPIVOTDATA-backed cells formatted at 28pt for the three headline numbers. Insert ▸ Slicer ▸ Region from one PivotTable, then right-click it ▸ Report Connections ▸ tick all three. Clicking "North" now redraws every chart and every headline number at once. The reason most Excel dashboards rot is layout, not charting: separating raw data, calculation and presentation is what lets the same file still work three months and four data refreshes later. If there is any chance you will reuse this, drop it into a small template tab right now: a labelled input area on the left and the formula beside it, checked once against the tool above. Next time the same question comes up, the answer is a single paste away instead of a rebuild from memory.
In Google Sheets
If you are in Google Sheets rather than Excel, the good news is that the formula shown here is identical and the workflow barely changes — menus sit across the top instead of in a ribbon, and a few function names differ slightly, but anything you build here moves across with little or no rework. Keep this page bookmarked for the next time the same question comes up. Better still, rebuild the example once in your own sheet — doing it yourself, with the tool above to check against, is what turns a copied formula into a technique you own. The short version of “excel dashboard templates free”: the answer is at the top of this page, the tool proves it on your own numbers, and the sections above explain why it holds so the next variation does not stump you. Excel rewards people who reference cells instead of typing values and who keep inputs separate from formulas, because that is what makes a result you can audit months later. Build it once, deliberately, with the live tool as a check, and you convert a one-off lookup into a reusable skill — which is the whole point of learning the why and not just the what.
Common mistakes
- Building charts directly off the raw sheet, so every layout change means rebuilding the chart ranges.
- Using fixed ranges instead of an Excel Table, so next month's rows are silently excluded.
- Adding a slicer and never connecting it to the other PivotTables, so one chart filters and the rest do not.
- Putting twelve charts on one screen; a dashboard that answers three questions well beats one that answers twelve badly.
- Leaving the Calc sheet visible, which invites people to edit the summaries by hand.
- Formatting numbers inconsistently across tiles, so the reader cannot compare them at a glance.
Frequently asked questions
How do I create a dashboard in Excel?
Separate the workbook into Data, Calc and Dashboard sheets. Make the raw data an Excel Table, summarise it with PivotTables on Calc, and put only PivotCharts, headline numbers and slicers on the Dashboard sheet.
How do I make one filter control every chart?
Insert a slicer from any PivotTable, then right-click it and choose Report Connections. Tick every PivotTable the slicer should filter — they must all share the same source data.
Do I need Power BI for this?
Not for a single-workbook dashboard that a team refreshes manually. Power BI earns its place when the data lives in several systems, refreshes on a schedule, or has to be shared with people who do not open Excel.
How do I keep it updating?
Base everything on an Excel Table so new rows are included, then use Data ▸ Refresh All. PivotTable Options ▸ "Refresh data when opening the file" makes it automatic.
Other ways people ask this
On the way here you may have searched this as “excel dashboard template”, “excel dashboard templates”, “free excel dashboard templates” and “free excel dashboard template” — it is all the same task, and this page is the single, complete answer to it.
Why do people search for this in so many different ways?
Because the same task has many names. “excel dashboard template”, “excel dashboard templates”, “free excel dashboard templates” all point at the one operation explained on this page, which is why they all lead here.