How to Build a Dashboard in Excel (Step by Step)

A clear, no-fluff walkthrough for making an interactive Excel dashboard with PivotTables, charts, and slicers, plus how to build it faster with AI and get one that refreshes on its own.

By the Quiriz Team · Published July 8, 2026 · 7 min read

A good Excel dashboard does one job: it takes a sheet nobody wants to scroll and turns it into a screen someone can read in about five seconds. KPIs up top, a couple of charts, a few filters to poke at. And the good news is you don't need add-ins or code for any of it. PivotTables, PivotCharts and slicers cover the whole thing. I'll walk through the build step by step, then point out where AI can take the fiddly bits off your hands.

What makes a good Excel dashboard

One screen. The key numbers are visible without scrolling.
Interactive. Filters let viewers answer their own follow-up questions.
Clean layout. A few clear charts beat a dozen cramped ones.
Refreshable. It updates when the data does, with one caveat we'll get to.

How to build a dashboard in Excel, step by step

The five-step path from a raw sheet to a working Excel dashboard.

1. Structure your data

Put raw data on its own sheet: one row per record, clear headers, no blank rows, and no merged cells (merged cells are where good PivotTables go to die). Select it and press Ctrl+T to format it as an Excel Table. A Table gives your PivotTables a clean, named source that grows on its own as you add rows.

2. Build PivotTables

On a new sheet, Insert → PivotTable from your table. Build one PivotTable per metric you want to show: sales by month, orders by region, revenue by product. Keep each one focused on a single question and resist the urge to cram three answers into one.

3. Turn them into PivotCharts

Select a PivotTable and Insert → PivotChart. Pick the chart type that fits the question: columns for comparisons, lines for trends over time, bars for rankings. Then move the charts onto one dedicated Dashboard sheet so they live in the same place.

4. Add slicers and timelines

This is the step that turns a page of charts into an actual dashboard. Click a PivotChart, then Insert → Slicer (for categories) or Insert → Timeline (for dates). Use Report Connections to wire one slicer to several PivotTables, so a single click filters everything at once instead of chart by chart.

5. Lay out and format

Arrange the charts on a rough grid, add a title and a row of KPI cells (big, bold numbers people can read from across the room), and turn off gridlines under View for a clean look. If other people will use it, protect the sheet so nobody drags a chart into orbit by accident.

Build an Excel dashboard faster with AI

AI cuts out most of the manual steps. Microsoft 365 Copilot can generate PivotTables and charts from a plain-English prompt like "show revenue by month as a line chart," right inside Excel. You still assemble the final layout yourself, but the charting and summarizing happen in seconds instead of a dozen clicks. AI data tools can also read an uploaded spreadsheet and spit out charts for you automatically.

The catch: Excel dashboards don't refresh themselves

An Excel dashboard is genuinely powerful, but it's static in one way: it updates only when someone reloads the source data and clicks Refresh. Email it around and you're soon juggling versions, each one a snapshot frozen at whatever moment it got saved. For one analyst on one file, that's fine. For a team that needs the same dashboard always current, that manual refresh quietly becomes the bottleneck.

Beyond Excel: auto-refreshing, shared dashboards

Once that manual refresh becomes the bottleneck, the fix is to stop rebuilding the thing by hand. With Quiriz you import the same spreadsheet as a dataset, ask for the view you want, and publish a dashboard the whole team can open, one that refreshes itself on a schedule so nobody's re-uploading a file every Monday morning. For a quick one-off chart, Excel is still faster and there's no reason to leave it. This is for the dashboard that's shared and has to stay live.

Want a dashboard that updates itself?

Import your Excel file, ask a question in your own words, and publish a shared dashboard that refreshes on its own. Free to start.

Try Quiriz free →

Frequently asked questions

How do I make a dashboard in Excel?

Put your raw data on its own sheet as an Excel Table, build PivotTables for the metrics you care about, turn those into PivotCharts, and drop the charts onto a dedicated dashboard sheet. Add slicers and timelines so viewers can filter, then clean it up with titles, KPIs, and gridlines switched off.

Can Excel make interactive dashboards?

Yes. Slicers and timelines connected to PivotTables and PivotCharts make an Excel dashboard interactive, so viewers can filter by category or date and every linked chart updates at once. It's interactive inside the workbook, though it still needs a manual refresh whenever the underlying data changes.

Can AI build an Excel dashboard for me?

Partly. Microsoft 365 Copilot can generate PivotTables and charts from a typed request right inside Excel, and AI data tools can turn an uploaded spreadsheet into charts on their own. You still assemble and lay out the final dashboard, but AI takes a lot of the manual work off your plate.

How do I make an Excel dashboard update automatically?

Inside Excel it's a manual job: reload the source data and click Refresh. If you want a dashboard that updates on its own and stays shared with a team, a dedicated tool that connects to your data and refreshes on a schedule (like Quiriz) takes that manual step away.