In Excel, there are three types of sparklines you can add — line, column, and win/loss.
Line and column sparklines are easy to understand since they are just tiny line and column charts.
On the other hand, a win/loss sparkline resembles a column chart and a box and whisker plot. This type of sparkline is good where the data is binary — win/loss, yes/no, true/false, 1/-1, etc…
The good news is, adding and formatting each one follows a similar process.
For this tutorial, let’s use the following dataset:
To insert a sparkline in Excel, select the cell in which you want the sparkline to reside in.
Then, on the ‘Insert’ tab…
Click the type of sparkline (on the ‘Sparklines section) you want to add.
Let’s try adding a line sparkline in our example.
After that, you will be asked for the data range.
To choose the range, either type into the field the range or click the up arrow button and select the cells that contain the data.
After selecting the data range, press ‘Enter’ on your keyboard or click the arrow down button on the window and click ‘OK’.