Sparklines

A sparkline is a tiny in-cell chart that provides a visual representation of data.

They are useful for casually glancing over data to spot trends and variation.

Moreover, they conserve space, negating the need to have an overload of full-scale charts cluttering up a worksheet.

There are three types:

1. Line — suitable for continuous data.
2. Column — suitable for continuous data.
3. Win/Loss — suitable for dichotomous data.

In the example, the historical average temperatures of 10 cities are shown for each month.

The Line and Column sparklines visualise these temperatures and emphasise the maximum and minimum values.

The Win/Loss sparkline, however, only shows whether the temperature was positive or negative — it ignores the magnitude.

The example data was sourced from Wikipedia.