What a dashboard is and how to build one in Excel: the definitive guide

Modern companies generate massive amounts of data, but having data is not the same as having information. A dashboard is the bridge between the two: a visual tool that summarizes your most important metrics on a single screen, giving you a clear view of your business at a glance. And no, you don't need Power BI or Tableau to start. With Excel, the tool you already have, you can build powerful, functional dashboards. This guide shows you how.

Step 1: define the purpose (less is more)

This is the most important step and the one most people skip. Before opening Excel, answer this question: what decisions do I want to make with this dashboard? A dashboard is not a dump of all your data; it's a curated selection of the few indicators (KPIs) that really matter.

Rules for choosing your KPIs:

• Pick 3 to 7 KPIs. More than that and the panel loses clarity and becomes noise.
• They must be actionable. If a metric goes up or down, do you know which lever to pull? If not, it's not a good dashboard KPI.
• Adapt KPIs to the audience. A dashboard for the CEO (financial KPIs) is not the same as one for a production manager (OEE and quality KPIs).

Step 2: structure your data (the engine room)

The data structure supports the dashboard: separate data from its visualisation.

• Tab 1: DATA. Your raw tables go here: a clean table, no merged cells, no formatting tricks.
• Tab 2: DASHBOARD. 100% dedicated to charts and visuals. It holds no data; it only reads from the DATA tab.

Why? Because this lets you refresh the dashboard simply by pasting new data into the DATA tab, without rebuilding charts every time.

Step 3: design the visuals (the art of clarity)

This is where your data comes alive. The goal is not pretty charts, but charts understood in under 5 seconds.

• Trend over time (monthly sales, weekly OEE): use a line chart. Avoid bars; they read trends poorly.
• Comparison across categories (sales by product, stoppages by cause): use bars or columns. Avoid lines.
• Composition of a total (% of sales by region): stacked bars, or a pie only with fewer than 5 categories.
• A single KPI vs a target (current revenue vs goal): a big-number card or a gauge. Never a complex chart for one number.

Pro tip: remove all noise from your charts: drop borders, unnecessary gridlines, and use color with intent (green for good, red for bad).

Common mistakes to avoid

• Starting with the chart instead of the decision you want to make.
• Mixing data and presentation in the same tab: you'll pay for it every month.
• Measuring everything: 15 KPIs is not control, it's anxiety.

Your action plan

• Today: write down the 3 decisions your dashboard should support, and the 5 KPIs that feed them.
• In 7 days: build the DATA tab with one month of history and your first two charts on the DASHBOARD tab.
• In 30 days: run the first monthly review with your team using only the dashboard. Note what nobody looks at and delete it.