Gyan Bytes: Excel Sparkleline

Home / Blog / 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 Line, Column, or Win/Loss.

Inserting-Sparkle-line

 

 

 

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

sparkle-select-range

 

 

 

 

A Sparkline is added to your workbook.

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

sparkle-example

 

 

 

 

 

 

 

 

 

 

 

Explore Sparklelines more to Make your Excel - Sparkle

* Contributed by Sunil Sirohi

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.