Gyan Bytes: Excel Sparkleline

Gyan Bytes: Excel Sparkleline

Gyan Bytes: Excel Sparkleline

What is a Sparkline?

Sparklines are small charts in a worksheet cell that provide a visual representation of data. You can use Sparklines to show trends in a series of values such as seasonal increases or decreases, economic cycles, or to highlight maximum and minimum values.

Create a Sparkline

On the Insert tab, in the Sparklines group, click the type of Sparkline you want to insert, such as LineColumn, or Win/Loss.

In the Create Sparklines dialog box, define your Data Range and Location Range, and then click OK.

A Sparkline is added to your workbook.

Given below are examples of how these sparklelines look along with the data.

Explore Sparklelines more to Make your Excel – Sparkle

* Contributed by Sunil Sirohi