Your KPI Table Shows This Month, Not the Trend: How to Use Sparklines on Slides

Your KPI table shows this month, not the trend: a KPI table with a sparkline beside each number

Most KPI slides are a table of this month’s numbers: revenue, new customers, churn, NPS. Each value is accurate. But a single number can’t tell anyone which way it is moving, and that is usually the first thing a board, a leadership team or an investor wants to know.

This guide is for founders, finance leads and anyone who builds business reviews, board decks or investor updates. It shows how to add sparklines, small word-sized trend lines, to a KPI table so every number comes with its direction, and how to design them so they clarify rather than clutter.

Why a number on its own can mislead

Imagine two companies that both report $48K in monthly revenue this month. In the first, revenue has climbed every month for a year, from $31K. In the second, it has fallen every month, from $70K. In a KPI table, both rows look identical: “Monthly revenue: $48K”.

Two line charts that both end at $48K monthly revenue: one rising from $31K, one falling from $70K

Readers fill the gap in different ways. Some assume the number is stable. Some remember last quarter’s figure and do the math in their heads. Some ask in the meeting, which is the best case, because at least the question gets answered. The worst case is that nobody asks, and a slide that looks fine hides a trend that isn’t.

The usual workarounds help a little. A “vs last month” column shows one step, not the trend. A separate line chart for each metric shows the trend, but takes a whole slide per number, and suddenly a one-slide summary becomes five. What you want is the trend and the number together, in the same row, at a glance.

What a sparkline is, and what it isn’t

A sparkline is a tiny line chart, about the height of a line of text, that sits right beside the number it describes. It has no axes, no gridlines and no legend. Its only job is to show shape: rising, falling, flat, volatile, or turning.

That is also its limit. A sparkline is not for reading exact values. Nobody should try to work out March’s figure from a line 40 pixels tall. The exact value you care about is already in the table; the sparkline adds the context around it.

Three features define a good sparkline:

  • Small: roughly the height of the text in its row, and a few times wider than it is tall.
  • Quiet: a thin, neutral line, with nothing around it.
  • Anchored: the last point is marked, so it connects to the number in the table.

Step 1: add the trend column to the table

Start with your existing KPI table and add one column, right after the current value. Each row gets its own sparkline covering the same period. The header of that column says what the period is, for example “Last 12 months”.

KPI table with monthly revenue, new customers, churn and NPS, each with a 12-month sparkline and the last point marked

With an illustrative set of numbers, the table now tells a much richer story. Revenue has climbed steadily for twelve months. New customers have drifted down for most of the year. Churn has crept up a little every few months. NPS has moved around but stayed roughly flat. The current values are the same as before, but the table now answers two questions instead of one: where are we, and which way are we heading?

Keep the table itself simple. Text left-aligned, numbers right-aligned, no heavy borders. Our guide to tables that make the answer findable covers this in more detail.

Step 2: mark the last point

A plain line leaves the reader to work out where “now” is. Most people will assume it’s the right end, but on a busy slide the line can blend into the row. Adding a small dot on the last point solves this: the dot is the number in the table.

You can optionally mark the highest and lowest points with small gray dots, which helps when the range matters, for example to show that this month is the year’s low. Stop there. Labels on every point, colored segments and trend arrows turn a sparkline back into a chart, and the table becomes noisy.

Step 3: use the same time span on every row

Sparklines invite comparison. When people see four little lines stacked in a table, they compare their shapes. That only works if every line covers the same period with the same number of points.

A common mistake is to mix spans: revenue for twelve months, customers for six, churn since launch. The lines look comparable, but they aren’t. A gentle slope over six months and a gentle slope over three years mean very different things.

Pick one span and one interval, such as twelve monthly points, and say it once in the column header. You don’t need to repeat it in every row.

Step 4: choose the scale on purpose

This is the decision people most often skip, and it changes what the sparkline says.

Own scale per row. By default, most tools scale each sparkline to fill its own height, from that row’s lowest value to its highest. This shows the shape of each metric clearly. The downside: small changes look dramatic. Revenue moving from $46K to $48K over a year can look like a steep climb, because the line fills the full height.

Shared scale. When several rows use the same unit, for example revenue by region, you can give them one shared range, ideally starting from zero. Now the lines show size as well as shape: a small region stays small, and a 4% rise looks like a 4% rise.

The same revenue from $46K to $48K drawn on its own scale, where it looks like a steep climb, and on a shared scale from zero, where it looks flat

Neither is wrong. Rows with different units, such as dollars, percentages and counts, usually need their own scale. Rows with the same unit often read better on a shared one. Whatever you choose, say it in a short note under the table, such as “each line on its own scale”. It takes five words and prevents a wrong conclusion.

Step 5: color only the rows that need attention

By default, every sparkline should be the same neutral gray. Then use color for the rows your slide is about, for example the metrics that have turned in the wrong direction, and make the slide title say what they show.

KPI table titled New customers are slipping and churn is creeping up, with only those two rows tinted and their sparklines darker

In our illustrative example, the title becomes “New customers are slipping and churn is creeping up.” Those two rows get a light tint and darker lines. Revenue and NPS stay gray. Without reading a word of the table, the audience knows where to look.

Avoid automatic red and green for “bad” and “good”. Many people find red and green hard to tell apart, and a rising line isn’t always good: rising churn is a problem. One accent color, used only where the title points, is clearer.

How to build sparklines in Excel, Google Sheets, PowerPoint and Google Slides

Excel. Select the cells that hold the twelve values, go to Insert → Sparklines → Line, and choose the cell where the sparkline should go. Then, on the Sparkline tab, tick Last Point under Show (and High Point and Low Point if you want them). For a shared scale, use Axis → Same for All Sparklines for both the minimum and maximum.

Google Sheets. In the cell where the sparkline should go, type a formula such as =SPARKLINE(B2:M2) and copy it down the column. The function accepts options for color and range, such as {"color","gray"}, so you can keep the lines neutral.

Getting them into slides. PowerPoint and Google Slides don’t have a built-in sparkline chart. The simplest route is to finish the table in Excel or Google Sheets, then copy the range and paste it into your slide as a picture. If the numbers will change every month, keep the source sheet as the master and re-paste each time. For a short table, you can also draw each trend as a small line chart with axes, gridlines and legend removed, or as a simple freeform line, but this takes more care to keep consistent.

Steps to build sparklines: Excel Insert then Sparklines then Line, Google Sheets SPARKLINE function, then paste the table into the slide as a picture

Whatever method you use, check the result at the size people will actually see it, including on a phone if the deck is likely to be forwarded. If a sparkline is too thin to see at that size, make the line thicker, not the chart bigger.

Common mistakes to avoid

  • Too many points. Daily data over a year turns a sparkline into a smudge. Twelve monthly points or eight quarterly points are usually plenty.
  • Different spans in one table. Every row should cover the same period.
  • Unstated scales. Small wiggles on their own scale can look like big swings. Say which scale you used.
  • Decoration. Gradients, area fills, shadows and colored segments make the table harder to scan.
  • Sparklines instead of a chart. If the slide’s main point is the trend of one metric, give it a proper line chart. Sparklines are for summaries with several rows.

A quick checklist

  • Does every row cover the same time span, stated once in the header?
  • Is the last point marked so it connects to the number?
  • Have you chosen the scale on purpose, and said which one you used?
  • Are the lines gray by default, with color only where the title points?
  • Can you read every line at the size people will actually see it?

Sparklines work especially well in board decks, monthly business reviews and investor updates, where one slide has to summarize many numbers. For the bigger picture of that kind of slide, see our guides to KPI charts that show the target, board meeting decks and choosing the right chart.

Note: all numbers and examples in this article are illustrative.

Want every number in your next board deck or business review to show where it’s heading? DeckBolt designs board decks, investor updates and executive presentations in PowerPoint and Google Slides. Request a free deck review.