Excel KPI card design

A KPI card works because of hierarchy: one element is large and everything else gets out of its way. When you size all four parts the same, the card reads as a paragraph instead of an answer. The job is to make the value unmissable and the supporting detail quietly legible.

You can build a card two ways, and both are fine as long as you pick one and repeat it. Cell-based cards are fastest: border a small range, merge a couple of rows for the value, and let formulas live right in the card. Shape-based cards use a rounded rectangle with its text linked to a cell (select the shape, type =, click the cell) so corners stay soft and the tile floats above the gridlines.

Either way, the recipe is the same. Reserve a tile of roughly 4 columns by 5 rows and fill it one shade off the dashboard background so it reads as a surface. Drop the value in the upper-middle. Put the uppercase label directly above or below it. Add the delta as its own small line, and drive its font color with conditional formatting based on whether the change is good or bad for that metric. Above target is good for revenue; below target may be good for defects or response time. If you want trend, insert a line sparkline in a thin row at the bottom.

Then comes the part most people skip: padding and alignment. Leave empty rows and columns inside the tile as breathing room, align every element to the same left edge, and round the corners (cell borders can't, but shapes and a subtle fill can fake it). Build one card perfectly, then copy it across - identical dimensions are what make a row of cards look designed instead of assembled. The same restraint that drives good dashboard design principles applies here at tile scale. The dashboard visual styles file takes the same anatomy and dials it way up into glossy rings and glowing cards.

Cards aren't always the right answer. For one compact summary, start with three to six headline figures - the numbers a decision actually hinges on, the ones that belong at the top of the sheet. They trade density for emphasis, so each card you add costs you a little of every other card's prominence.

When more cards make the summary harder to scan, ask whether those metrics belong in a table. A multi-topic dashboard can use separate, clearly labeled card groups; the seventh metric is not a magic cutoff. A table is denser, scannable, and honest about detail - it's the right home for "all the other metrics" that readers occasionally need to sort or compare. The clean rule: cards carry the answer, tables carry the evidence. A good dashboard usually has both, stacked: cards across the top, a tidy table beneath. For the bigger picture of where cards sit on the page, see dashboard examples and the gallery.