Data Visualisation for Dashboards

Choosing Charts That Actually Communicate

Most dashboards use the wrong charts. Not because the designer lacks chart knowledge, but because charts get chosen before anyone asks what question the data answers. A chart's job on a dashboard is to make one thing obvious in under five seconds. If it takes longer, it belongs in an analysis tool, not on a daily-use screen.

The problem is not a lack of options. Modern charting libraries and BI tools offer dozens of chart types, colour palettes, animation effects, and customisation settings. More options produce worse choices. Teams pick charts that look impressive in a stakeholder demo or that the tool suggests by default, rather than charts that answer a specific operational question at a glance. The result is dashboards full of decoration disguised as data.

For broader data visualisation principles (chart theory, perceptual science, interactive exploration, data storytelling), see our guide to data visualisation. This page is about the specific, constrained world of dashboard charts: what works when space is limited, attention is measured in seconds, and every pixel has to justify its existence.


The Right Chart for the Right Question

Every metric on a dashboard answers a question. The chart type must match the nature of that question, not the shape of the data or the preference of the designer. Four relationships cover nearly every dashboard scenario. Picking the wrong chart for the relationship is how dashboards end up confusing instead of clarifying.

Before reaching for a chart, name the question. Then choose the chart that answers it most directly. This is not aesthetic preference. It is grounded in perceptual science: the human visual system processes length faster than angle, angle faster than area, and position faster than colour saturation. Cleveland and McGill's research on perceptual accuracy established this hierarchy, and it explains why certain chart types communicate certain relationships better than others.

Data Relationship Best Chart Common Mistake
Comparison
How does X compare to Y?
Horizontal bar chart, sorted by value. Length is the easiest visual property to compare accurately. Pie chart with 8+ segments. The eye cannot compare angles precisely, especially for similar-sized slices.
Trend over time
Is it going up or down?
Line chart (one series) or sparkline. Direction and rate of change visible instantly. Multi-series line chart with legend. Competing lines force decoding instead of glancing.
Composition
What makes up the whole?
Stacked bar or donut chart, limited to 2-4 segments. Proportions clear at a glance. Pie chart with 8+ slices. Small segments become indistinguishable slivers with labels fighting for space.
Correlation
Does X relate to Y?
Scatter plot (rare on dashboards). Best kept in analysis tools where exploration is the goal. Dual-axis line chart implying correlation. The crossing point is an artefact of axis scaling, not a real relationship.

One rule applies across all four types: if the chart needs a legend to be read, simplify it. Legends on dashboards are a sign that the chart is doing too much. Label directly on the chart elements, or reduce to a single series. Direct labelling (placing the value or category name on or beside the bar, line, or segment) eliminates the back-and-forth eye movement between legend and data that slows comprehension.

Multi-series line charts deserve special mention because they are the single most overused chart type on dashboards. Three or four lines in different colours, each requiring the viewer to glance between legend and data. On an analysis screen where the user is actively investigating, this works. On a dashboard designed for a five-second status check, it fails. The fix: split into individual sparklines or single-series charts, each with a clear title. One chart per question. This decomposition is the single highest-impact change most dashboards can make.


When No Chart Is the Answer

Sometimes the best visualisation is not a chart at all. A number with context often communicates faster than any graphic. The instinct to add a chart to every metric is strong, especially when the tool makes it easy. Disciplined dashboard design resists that instinct. Charts earn their place only when the visual encoding adds something that the number alone cannot convey.

Three patterns cover most situations where a simple indicator outperforms a chart. These are not shortcuts or compromises. They are often the clearest possible way to communicate the metric.

Numbers with Context

Revenue: £47,000 of £60,000, up 12% month-on-month. Two numbers and a percentage, no chart required, understood in under a second. The pattern (current value + target + trend indicator) is the foundation of every effective KPI card. Context turns a data point into information.

Traffic Light Status

The brain processes colour faster than quantity. A green indicator beside "System Health" communicates more at a glance than a 98.7% uptime chart. Red, amber, green (always paired with a label or icon for accessibility) communicates categorical status with zero cognitive overhead.

Progress Bars

For anything with a defined target, a progress bar shows position and remaining gap simultaneously. Pipeline at 73% of quarterly target. Recruitment at 4 of 6 hires. The bar gives proportion; the numbers give precision. Less space than a chart, more clarity.

A useful heuristic for choosing between charts and indicators: if the metric has a clear target, use a number with comparison or a progress bar. If the metric has a meaningful trend, use a sparkline. If the metric needs comparison across categories, use a bar chart. Only reach for more elaborate charts when these simpler options genuinely fall short. The best dashboards use a deliberate mix: charts for trends and comparisons, simple indicators for current status and targets.


Sparklines: The Dashboard Workhorse

A sparkline is a tiny, word-sized chart (usually a line) that shows trend over time without axes, labels, or legends. Edward Tufte coined the term: "data-intense, design-simple, word-sized graphics." On dashboards, they are indispensable. No other chart type delivers as much information per pixel.

Sparklines work because they answer the most common dashboard question (is this going up or down?) in the smallest possible space. They also solve the "compared to what?" problem without requiring a full chart. A single number provides no sense of history. A sparkline provides twelve months of history in a space no larger than a postage stamp.

How sparklines earn their place: A KPI card showing "Revenue: £47,000" tells you the current state. Add a sparkline showing the last 12 months and you also see trajectory, volatility, and seasonality. No extra space required. No extra cognitive load. The shape tells the story that the number cannot.

Sparklines are versatile, but they have clear limits. Understanding where they excel and where they fall short prevents misuse. They are particularly effective in operational dashboards where many metrics need simultaneous monitoring and space is at a premium.

Inside KPI cards: Beside the headline number, showing whether the metric is trending up, down, or flat over the last 6-12 periods.
Inside table rows: Showing trend for each row item (each team, region, or product) without expanding the table into a full chart grid.
In status panels: Giving trend context to multiple metrics in a compact space where full charts would overwhelm the layout.
For precise values: Sparklines show shape, not precision. You cannot and should not try to read exact values from them.
For comparing series: Two sparklines side by side may have completely different scales. If comparison is the goal, use a proper chart with a shared axis.
As a replacement for full charts: When the trend itself is the primary focus of a dashboard panel, a full line chart with axis and labels is the right choice. Sparklines supplement; they do not substitute.

The best sparkline implementations highlight the endpoint (current value) and optionally mark the high and low points. Keep them simple: a line, possibly a shaded area beneath, and one or two reference dots. The aspect ratio matters: width should significantly exceed height, following Tufte's "banking to 45 degrees" principle, so that trends are neither exaggerated nor flattened. Anything more complex defeats the purpose of a word-sized graphic.


Data-Ink Ratio: Every Pixel Earns Its Place

Edward Tufte's data-ink ratio is a simple principle: maximise the share of pixels devoted to actual data, minimise everything else. On dashboards, where space is scarce and attention is brief, this is not theory. It is practical survival.

Every non-data element on a dashboard competes with the data for attention. Gridlines, background shading, decorative borders, 3D effects, gradient fills, ornamental icons: they all consume visual bandwidth without adding information. On an analytical tool with generous screen space, a bit of decoration is harmless. On a dashboard where twenty metrics share one screen, every unnecessary pixel steals attention from the data that matters.

The practical test: look at any element on a chart and ask, "If I remove this, do I lose information?" Apply it without sentiment.

Background colours on chart panels: Shaded backgrounds behind charts add visual weight without adding information. A white or transparent background lets the data stand forward.
Gridlines (most of the time): When bars have data labels, gridlines are redundant. They add visual noise to every chart that could be cleaner without them.
3D effects and gradient fills: Perspective distorts proportions. Gradients make it harder to judge where a value sits. Both add complexity without adding information.
Decorative icons beside labels: A chart icon next to the word "Revenue" wastes space. The viewer already knows they are looking at a chart.

What survives the data-ink test is always the same small set of elements.

Data labels: The actual values, directly on or beside the elements they describe. No hunting required.
Axis labels where needed: Time axis on a line chart, category labels on a bar chart. Only when the data is not self-evident.
A single reference line: Target or average. One line that gives context to all data points. More than one reference line and the chart becomes cluttered.
Semantic colour: Green, amber, red carrying meaning (on track, watch, act). Colour that communicates status, not colour that decorates.
Clear titles: What is this chart showing? A concise title means the viewer never has to guess.

Everything else is negotiable. And most of it should go.

The practical exercise: Take a screenshot of your busiest dashboard chart. Remove one element at a time: gridlines first, then background colour, then borders, then decorative elements. Stop only when removing something would genuinely make the chart harder to read. The version you end up with is the version that belongs on the dashboard.


Colour as a Dashboard Vocabulary

Colour on dashboards is not decoration. It is a language. When used consistently, colour communicates status, trend, and urgency faster than any text label. When used inconsistently or decoratively, it becomes noise that the viewer learns to ignore.

The foundation is a semantic colour vocabulary that means the same thing on every dashboard, every chart, and every indicator across the organisation. Users learn this vocabulary once and recognise it everywhere.

Green: On Track

The metric is healthy. No action needed. The viewer's eye should skip green items and move to items that need attention. Green means "ignore safely."

Amber: Watch

The metric is approaching a threshold or trending in the wrong direction. Not yet a problem, but worth monitoring. Amber means "check back soon."

Red: Act

The metric has breached a threshold or requires immediate attention. Red items should be rare. If everything is red, the thresholds are wrong or the system has deeper problems than a dashboard can solve.

Beyond status, colour serves two other dashboard functions. A highlight colour (typically a brand accent or strong blue) draws attention to the current period, selected item, or primary data series against a neutral grey for everything else. And categorical colour (used sparingly, for 2-4 categories only) distinguishes segments in a composition chart. Beyond four categories, colour distinction breaks down and direct labelling is more effective.

What colour must never do on a dashboard: distinguish twelve categories with a rainbow palette (forcing legend-checking for every data point), vary between dashboards so that green means different things in different contexts, or serve purely decorative purposes through gradients and aesthetic fills.

For users with colour vision deficiency (roughly 8% of men), colour must never be the sole encoding. Pair every colour signal with an icon, text label, or pattern. A red indicator with an exclamation mark works for everyone. A red indicator alone excludes a significant portion of users. This is covered in more depth in the dashboard UX guide.


Charts for Different Dashboard Types

The right chart depends not only on the question but also on the type of dashboard. An executive dashboard and an operational dashboard serve different audiences with different time pressures, and their visualisation choices should reflect that.

The underlying principle is density: how much information the viewer can process in the time they will spend looking. Executive viewers spend seconds. Operational viewers spend minutes. Analytical viewers spend hours. Chart complexity should match available attention.

Dashboard Type Visualisation Approach Avoid
Executive
5-second status check
KPI cards with sparklines, traffic lights, progress bars. Five to seven metrics maximum. Every number has context (vs target, vs last period). Complex charts, multi-series lines, scatter plots. Anything requiring study.
Operational
Continuous monitoring
Higher density. Bar charts for queue sizes, sparklines for throughput, traffic lights for system health. Real-time or near-real-time refresh. Exception-based colouring so problems announce themselves. Pie charts, decorative elements, charts without status encoding. Anything that requires interpretation rather than recognition.
Sales
Pipeline and activity focus
Pipeline bar chart by stage, KPI cards for target progress, lists of deals needing attention. Progress bars for monthly target tracking. Sparklines for trend context. Scatter plots, area charts, complex compositions. Anything that does not directly answer "are we on track?" or "what needs attention?"

The common thread: simpler dashboards with fewer, more deliberate chart choices outperform complex dashboards with elaborate visualisations. The layout and visual hierarchy guide covers how to arrange these charts spatially for maximum impact.


Common Dashboard Chart Mistakes

These mistakes appear on dashboards repeatedly, across industries and tools. Each one makes the dashboard harder to read, and each has a straightforward fix. The pattern is consistent: every mistake prioritises how the chart looks over how it communicates.

Pie charts with too many segments: Beyond four or five slices, the eye cannot compare angles accurately. Small segments become meaningless slivers with labels fighting for space. Replace with a sorted horizontal bar chart for immediate improvement.
3D charts of any kind: Perspective distortion makes closer segments appear larger and distant ones smaller, regardless of actual value. A 3D pie chart can make a 20% slice look bigger or smaller depending on its position. All dashboard charts should be flat.
Dual-axis charts: Two Y-axes tell two stories simultaneously. The viewer cannot tell where lines cross meaningfully versus where the crossing is an artefact of axis scaling. The apparent relationship changes depending on how the axes are scaled. Split into two separate charts. More space, more honesty.
Rainbow colour palettes: When every bar is a different colour for no semantic reason, the colour becomes noise. Use colour to encode meaning (red for behind target, green for ahead) or to highlight one item against a neutral background. A rainbow forces legend-checking for every data point.
Charts designed for presentations, not daily use: Area charts with gradient fills, animated transitions, complex layered compositions. They look impressive in a slide deck. On a dashboard checked at 8am every morning, they slow comprehension. The chart that works daily is the one that is boring and obvious.
Truncated Y-axes on bar charts: A bar chart starting at a value other than zero exaggerates differences. A bar that looks twice as tall should represent twice the value. Truncated axes distort perception, and once a user notices the distortion, trust in the entire dashboard erodes. Line charts have more flexibility (showing a narrow range of change is legitimate for trends), but bar charts must always start at zero.

Every one of these mistakes has the same root cause: defaulting to how the chart looks rather than asking how it communicates. On a dashboard, communication is the only metric that matters. A chart that accurately and instantly conveys its message in the plainest possible way is better design than any visually elaborate alternative.


What Good Dashboard Visualisation Gets You

When chart choices are made deliberately (matched to questions, stripped of decoration, tested against the data-ink principle), the dashboard becomes a tool people rely on rather than tolerate. Each of these outcomes builds trust, and trust is what turns a dashboard from a reporting obligation into a daily habit.

  • Metrics understood in seconds Each chart answers one question instantly, without study or interpretation.
  • Trends visible at a glance Sparklines embedded in KPI cards show direction without consuming full chart panels.
  • Problems surface before anyone asks Semantic colour and clear indicators make exceptions obvious without requiring investigation.
  • No chart without a purpose Every visualisation on the dashboard has earned its place by communicating something a number alone cannot.
  • Honest representation of data No distortion from 3D effects, truncated axes, or misleading dual scales. Trust in the data stays intact.
  • A dashboard that earns its daily check People open it because it genuinely helps them work, not because they were told to. That is the only success metric for a dashboard.

The common thread: chart choices are communication decisions, not aesthetic ones. The right chart makes understanding instant. The wrong chart makes the dashboard work against its own purpose.


Go Deeper

Chart selection is one part of dashboard design. The best chart in the wrong position is invisible. The right interaction pattern turns a static display into an investigative tool. And the principles here extend beyond dashboards into broader data communication.

Layout and Visual Hierarchy →

Where charts and indicators sit on the dashboard and why position matters. Z-pattern scanning, the inverted pyramid, grouping, and density trade-offs.

UX and Interaction Design →

How users drill down from charts, filter data, and interact with dashboard visualisations. Progressive disclosure, performance, and accessibility.

Data Visualisation (Broader Guide) →

Chart theory, perceptual science, interactive exploration, and data storytelling beyond the dashboard context. For deeper visualisation thinking.

Back to Dashboard Design →

The pillar page covering the full dashboard design approach: what belongs on dashboards, role-specific views, the design process, and common pitfalls.


Charts That Communicate, Not Decorate

We design dashboard visualisations that answer your team's actual questions. The right chart, sparkline, or simple indicator for each metric, stripped of clutter, built for the daily glance. Not default chart library settings. Deliberate choices matched to the questions your people ask, presented honestly and clearly.

Let's talk about your dashboard →
Graphic Swish