How to Create a Dashboard in Excel (in One Click)
Building a dashboard in Excel normally means an afternoon of PivotTables, PivotCharts, and fiddly layout. Here's why it's so slow — and the one-click way to get KPI cards and charts on a fresh sheet.
Last updated: August 2026
| Your table | Dashboard sheet | |
|---|---|---|
| Sales by region & month | → | KPI cards (total, top region) |
| 1,000 order rows | → | 3–4 charts (auto-picked) |
Why the manual way takes hours
To summarise your data you build a PivotTable for each cut, then a PivotChart on top of each one, then hand-craft KPI cells with SUM, SUMIFS, and MAX and arrange everything into a readable layout. It's a lot of clicking for one view, and every time the source data grows you refresh, re-check, and re-format. There's no built-in "make me a dashboard" button.
The 1-click way — Tellsheet's Instant Dashboard
Select your table and run Instant Dashboard. Tellsheet reads your columns, writes a new sheet, and lays out KPI cards for the key totals alongside three or four charts chosen automatically from the data — no PivotTables to set up. Everything is ordinary Excel charts and cells, so you can restyle or extend it freely. Pairs with Interactive Report and PivotTable Alternative.
Frequently asked questions
Do I need to build PivotTables first?
No — Instant Dashboard reads your selected table directly and generates the KPI cards and charts for you, so there's nothing to set up.
How does it choose the charts?
It inspects which columns are categories and which are numeric, then picks three or four fitting charts plus KPI cards for the main totals.
Where does the dashboard go?
Onto a new sheet, leaving your original table untouched. Delete or re-run it whenever you like.
Can I edit the charts afterwards?
Yes — they're normal Excel charts and cells, so restyle, move, or extend them exactly as you would your own.
Related Excel guides
Build a dashboard in one click
Instant Dashboard turns your table into a sheet of KPI cards and charts — no PivotTables, no manual layout.
Get Tellsheet free See pricing