How to Create Sparklines in Excel 2010

In this article I am going to explain about Sparklines in Excel 2010
  • 2773

Sparklines in Excel 2010

Sparklines is small chart that fit in single cell. Its show flow of data into single cell and we can use its instead of chart. its is very help full when we want to display chart for every record in worksheet. Sparkline is the new feature in Excel 2010. There are three types of Sparkline.

Line, Column and Win/loss.

How to create Sparklines

Step 1

Open work sheet and select cell where we want to create sparklines.

Spark1.jpg

Step 2

On Insert tab in Sparklines group we can choose any type of sparkline.

spark2.jpg

Step 3

Then a Create Sparklines dialog box will be open.

spark3.jpg

Step 4

In Sparklines dialog box we will enter cell name where we want to create sparkline and click ok.

spk1.jpg

Step 5

Finally sparklines will be create.

spark_l.jpg

Ask Your Question 
 
Got a programming related question? You may want to post your question here
 

Categories

More Articles

© 2020 DotNetHeaven. All rights reserved.