Open Data·Open Metrics
Open Data Waterloo Region · Note

Dashboard Design: 9 Rules for Dashboards People Actually Open

July 18, 2026 · Uncategorized

Most dashboards die in the first week. Not because the numbers are wrong, but because nobody opens them after the demo. A dashboard nobody opens is not a dashboard, it is a very expensive screensaver.

Dashboard design is the practice of arranging metrics so one specific person can make one specific decision in seconds. That definition quietly disqualifies most of what gets built. A wall of 30 charts is not a dashboard, it is a data dump with a title bar and a refresh button.

What follows is a working system, not a mood board. Nine rules, in the order you should apply them, with the gotchas that cost people a redesign.

Dashboard design starts with one sentence, not one chart

Every design choice traces back to one question: who is looking, and what do they do next? An executive scanning revenue before a board call needs a different screen than an ops lead watching a support queue at 9am. Same company, same database, two different dashboards.

Before you place a single visual, finish this sentence:

“This dashboard helps [role] decide [action] by watching [3-5 metrics].”

If you cannot fill in the blanks, you are not ready to build, you are ready to go ask the person who requested it what they actually plan to do with it. Nine times out of ten the answer shrinks the metric list by half.

Rule 1: Pick fewer KPIs, and give each one a target

A metric quantifies an activity. A KPI is a metric tied to a goal. The difference is a target. “Revenue: $412k” is a number. “Revenue: $412k against a $450k target, red” is a decision.

Cap the headline row at 4 to 6 KPIs. Past six, people stop reading and start hunting, and hunting is the behavior that kills a dashboard. Every KPI on the top row needs three things: a target, an owner, and a time frame. A KPI with no owner is trivia.

Mix one or two leading indicators in with your lagging ones. Lagging indicators (revenue, churn) confirm what already happened. Leading indicators (pipeline created, trials started) tell you what is coming. A dashboard built only on lagging metrics is a rear-view mirror with excellent resolution.

Rule 2: Use the F-pattern, because that is how people read screens

Eye-tracking research is boring but consistent: on data-heavy screens people scan in an F shape. They read the top line, sweep down the left edge, and glance across again lower down. The top-left corner gets the most attention of any pixel on the page.

So put the single most important metric in the top-left. Not the logo. Not a date slicer. The number the whole dashboard exists to report. Everything else arranges outward from there in descending order of importance.

Pair the F-pattern with the inverted pyramid. Status and targets go at the top. Trends and comparisons that explain the movement sit in the middle. Detail, owners, and links to dig deeper live at the bottom. A reader who stops after the top row still leaves with the one thing that mattered.

Rule 3: Match the chart to the question

Chart choice is not taste, it maps to the shape of the question. Comparing categories is a different job than tracking a trend, and each has a right answer.

The questionThe chartWhy
How do these categories compare?Horizontal bar, sortedLength is easy to compare; sorting does the ranking for the reader
How has this moved over time?Line chartConnected points show direction and volatility at a glance
How do two variables relate?Scatter plotPosition on two axes reveals correlation and outliers
What is the single headline number?KPI cardNo axis, no clutter, just the value against a target
Where does the pipeline leak?Funnel chartStage-to-stage drop-off is the whole point
What are the parts of a whole?Stacked barReads better than a pie and scales past a few slices

One opinion I will defend: a pie chart falls apart above five slices, and a lot of the time it fails at three, because humans judge angles badly. If you have more than a handful of categories, a sorted bar chart wins every time. Nobody has ever squinted at a bar chart trying to tell 22% from 25%.

Rule 4: Color encodes meaning, not decoration

Pick one accent color and one neutral gray, then stop. Color should carry information: red for a breached target, green for on track, gray for everything that is just context. The moment you use five colors because they look nice, you have taught the reader that color means nothing, and they will ignore it when it finally does mean something.

Two hard constraints. Do not rely on red versus green alone, because roughly 1 in 12 men cannot separate them cleanly; add an icon, a position, or a label so the status survives without color. And keep text contrast at 4.5 to 1 or higher, the WCAG AA floor, or half your audience reads your dashboard with a slight headache.

Rule 5: Delete ink that carries no data

Edward Tufte gave us the data-ink ratio: the share of pixels doing real work versus the total. Heavy gridlines, drop shadows, gradient fills, 3D bars, and redundant legends all lower it. If a pixel is not telling the reader something new, remove it.

Practical version of the rule:

White space is not wasted space. Give the layout 40 to 60% breathing room and the important numbers stop competing with each other for attention.

Rule 6: Design to the 5-second test

Here is the only usability test that matters for dashboard design. Show the finished screen to someone for five seconds, take it away, and ask: are we on track, and where is the problem? If they cannot answer, the design failed, no matter how clean it looks.

Most dashboards fail this test because they treat every metric as equally urgent. Ranking is the fix. The eye should land on the headline, then be pulled to whatever is red. If everything is the same size and color, you have built a spreadsheet with rounded corners.

Rule 7: Put a title on it that states the question

“Sales Dashboard” tells the reader nothing they did not already know. “Are we on pace to hit Q3 quota?” tells them exactly what the screen answers, and it quietly disciplines you into cutting anything that does not help answer it.

The same logic runs down to individual visuals. A chart titled “Revenue” is a label. A chart titled “Revenue is flat for the third month” is an insight, and it is the kind of thing that gets a dashboard forwarded instead of closed.

Rule 8: Match refresh to the decision, not to the demo

Stale data erodes trust faster than an ugly chart ever will. The first time an exec spots a number that disagrees with the number they saw in a meeting, the dashboard is dead and no amount of design saves it.

Refresh cadence should follow the metric, not a habit:

Stamp the last-refresh time on the dashboard. A visible timestamp turns “is this current?” from a trust problem into a non-question.

Rule 9: Avoid the mistakes that force a redesign

A reusable dashboard design layout

Steal this wireframe. It applies whether you build in Power BI, Tableau, or a spreadsheet.

Build that, run the 5-second test on a colleague, and cut whatever they could not read in time. The best dashboard design decision you make is usually a deletion.

Keep reading

The full dashboard design series

← All community notes