A good dashboard answers one question quickly. A bad dashboard shows everything and answers nothing. Plan first, then build.
Step 1: Plan
Write the questions the dashboard must answer. For a sales dashboard: What are total sales? Which region is leading? How are we doing against target?
Step 2: Prepare clean data
Put your data in a table (Ctrl + T). Fix dates, remove blanks and make sure each column has one type of data.
Step 3: Build the numbers
Create a pivot table or formulas for each KPI: total sales, orders, average order value, growth.
Step 4: Add charts
- Column or bar chart for comparing categories
- Line chart for trends over time
- Avoid 3D charts and too many colours
Step 5: Make it interactive
Add slicers or a drop-down list so the user can pick a region, month or product, and every chart updates.
Step 6: Polish and share
Hide gridlines, align items, use one colour theme, and lock cells you do not want people to change. Save a copy as PDF if the reader only needs to view it.
Common mistakes
- Too many charts on one page
- No clear title or date of last update
- Totals that do not match the source data
Go deeper
Our Advanced Excel course has a full chapter on interactive dashboards, including KPI cards, selectors, dynamic charts and a complete sales dashboard project.