What is Spark lines in Excel and How to use it in 3 different ways?

What is Spark lines in Excel

Sparklines also known as micro charts adds rich visualization to tabular data without taking much space. This bit size graph can fit in a cell and can provide powerful insight.

Where to find Sparklines in Excel?

Go to Excel sheet >> Insert >> Sparklines

What are sparklines in excel
How to find Sparklines

How many Sparklines available for use?

There are three Sparklines available in excel. Line, column and Win/Loss.

Line Sparkline: It is the first sparkline and can be used with high number of data points like date.

Go to sparklines tab in Insert option and click Line, we will get a pop up like below.

Sparklines 2
Line Sparkline Creation

We will select F7 to AB7 in Date RangeContinue Reading