Sparkline in Excel 2010

A Sparkline is a small chart that is aligned with rows of some tabular data and usually shows trend information.

1.     Select the data from which you want to make a Sparkline.

2.     Go to Insert > Sparkline and select the type of Sparkline

3.     Specify a target cell where you want the Sparkline to be placed

4.     Optional: Format the Sparkline if you want.

There are 3 basic types of Sparkline in Excel 2010.

1.     Line chart

2.     Column chart

3.     Win-loss chart.

 

 

Selection of Sparkline (Last Set)

 

Data Selection for Sparkline

 

Sparkline Formatting

 

Keep Learning
Sanjay Bakshi
mesanjaybakshi@gmail.com