Building an Interactive Excel Dashboard
Table, slicers and a filled map chart — the six clicks a screen-recording doesn't slow down for. This guide walks through each step, and the download includes a workbook where the dashboard is already built, so you can see it working before you build your own.
Free · PDF guide + Excel dashboard · instant download, no email required
Download the Guide — FreeInstant PDF + Excel workbook, no signup.
Who This Is For
Veteran business owners and side-hustlers who already track jobs, revenue, or costs in a spreadsheet and want it to work like a real dashboard instead of a wall of numbers. No advanced Excel background needed — the guide assumes you can click a cell and follow six steps, and the workbook does the setup for you.
What's Inside
- Why your data has to be a real Excel Table before slicers will work, and how to convert one with Ctrl+T
- The six steps: inserting slicers, moving them onto a dashboard sheet, and sizing them to fit
- Building a filled map chart from two columns and connecting it to your slicers
- Chart formatting: fill, border, title, and showing only the regions with data
- Two honest limits of Excel's filled map, and when to use a bar chart instead
- How the Summary sheet's SUMIFS formulas total revenue and profit by line automatically
What's In The Download
This download is two files, not one. The PDF guide walks through the six steps in order. The Excel workbook (.xlsx) is the finished example — the dashboard is already built, so you can click the slicers and see it work before you try it on your own numbers.
The workbook's Data sheet is already a named Excel Table (VSGData) with the columns the dashboard depends on: Month · Line · State · County · Jobs · Revenue · Cost · Profit — Profit is a formula that fills itself in on new rows. The Dashboard sheet has Month and Line slicers already dropped in and connected, plus a filled map chart by state. A Summary sheet totals revenue and profit by line with SUMIFS, so it updates as you add data. Every figure in the sample data is invented (it spans Kansas, Missouri, Nebraska, Oklahoma, and Colorado just to give the map something to show) — the structure is real, the numbers are placeholders to type over.
Two Honest Limits, Named Up Front
- A filled map by state only earns its space if you actually work in more than one state. Stay inside Kansas and it's decoration — delete it and use a bar chart of Revenue by Line instead. Same slicers, more useful.
- Excel's filled map cannot do counties. It handles countries, states, and some metro areas; county-level mapping needs Power BI or a different tool. The County column stays in the data because it's worth tracking, not because the map will read it.