Microsoft Excel 
ITTraining@sgul.ac.uk Page 36 St. George’s Information Services 
QUICK SPARKLINES 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Sparklines are mini charts that are embedded 
into a worksheet, usually immediately adjacent to 
the data. Sparklines are only relatively new in 
Excel and probably haven’t gained the 
acceptance or understanding that Microsoft would 
like. So, you’ll now find them in the Quick Analysis 
tools where you can easily implement them without 
too much head scratching. 
Try This Yourself: 
Open 
File Before starting this 
exercise you MUST open 
the file E1355 Quick 
Analysis_4.xlsx… 
 
Click in cell B5, hold down 
, then click in cell E9 
to select the range B5:E9 
 
Click on the Quick 
Analysis button, then 
click on the 
SPARKLINES tab  
 
Point to Line to display a 
line drawing showing 
trends for each row 
across the four weeks 
 
Point to Column to 
display the trend as 
columns rather than a 
continuous line 
 
Click on Column to add 
Sparklines in column F 
Notice that after the 
Sparklines have been 
created the SPARKLINE 
TOOLS tab on the ribbon 
is now available so that 
you can further enhance 
or modify the Sparklines 
 
3 
5 
For Your Reference… 
To use Quick Sparklines in a worksheet: 
1. Select the range to be analysed, then click 
on the Quick Analysis button 
2. Choose the desired Sparkline from the 
SPARKLINES tab 
Handy to Know… 
 The Win/Loss is a special type of Sparkline 
that shows positives above an imaginary line 
and negatives below it. You need to have 
values range from the negative to the 
positive to make any good use of it.