Sometimes the trend matters but a full chart is overkill. Say you have thirty products and want each one's twelve-month sales trajectory beside its row in the table. You don't want thirty separate charts. A sparkline is a word-sized chart drawn inside a single cell. It has no axes and no legend, and nothing is labelled. All you see is the shape of the series. Edward Tufte coined the term for this kind of graphic, one "with typographic resolution," small enough to sit in running text or a table cell and dense enough to show the trend. Its power comes from small multiples. A column of sparklines, one per row, lets the eye scan thirty trends in the time it takes to read thirty numbers, and the one product falling off a cliff stands out.
Excel offers three types. Line draws the trajectory and is best for continuous trends. Column shows discrete magnitudes, which suits a few periods or win/loss magnitudes. Win/Loss is a binary up-or-down mark. Each period gets a small block above or below a midline, whatever its magnitude, which makes it ideal for "did we beat target this month? yes/no/yes/yes/no".
Advertisement
How do you insert and format sparklines in Excel?
Select the cell or cells where you want the sparklines to appear, then Insert ▸ Sparklines ▸ Line / Column / Win-Loss. In the dialog, set the Data Range, which holds the source values (e.g., B2:M2 for one row's twelve months), and the Location Range, which is where the sparkline goes. Select many rows of data and many destination cells at once and Excel draws one sparkline per row. Once they're created, the contextual Sparkline tab appears. Tick High Point and Low Point to mark the peak and trough, and Markers to dot each value. The next step matters most for comparability. Open Axis ▸ Vertical Axis Minimum/Maximum Value ▸ Same for All Sparklines, so a tall spike in one row isn't drawn the same height as a small bump in another. Without a shared axis, sparklines mislead the same way a truncated bar axis does. To clear them, use Sparkline ▸ Clear. Pressing Delete on the cell doesn't remove a sparkline, and that catches plenty of people the first time.
When is a sparkline better than a full chart?
Sparklines beat a full chart when the message is the comparison across many rows and the precise values don't matter. The moment a reader needs to read a specific value, see an axis, or grasp one series in detail, the full chart wins.