Excel Sparklines

This post will explain that how to insert or create a Sparkline in one certain cell based on the selected data range in Excel. How to create a Line Sparkline in one Cell. How to create a Column Sparkline in Excel. How to change the Sparkline type from Line to Column type in Excel 2013 or Excel 2016. How to change the Sparkline style for an existing Sparkline.

What is a Sparkline?

The Sparkline is mini chart placed in single cell, and each chart representing a row of data in your selection.

Create Line Sparkline

If you want to create or insert Line Sparkline, just do the following steps:

1# Select one cell where you want to display the Sparkline, such as: Cell E2

excel sparklines1

2# go to Insert Tab, Click Line button under Sparklines group.

excel sparklines2

3# the Create Sparklines window will appear. Then choose the data range that you want, such as: B2:D2.

excel sparklines3

4# click Ok button, then let’s see the result.

excel sparklines4

Create Column Sparkline

If you want to create or insert Column Sparklines, just do the following steps:

1# Select one cell or range where you want the sparklines to be placed, such as: range E2:E4

excel column sparkline1

2# go to Insert Tab, Click Column button under Sparklines group.

excel column sparkline2

3# the Create Sparklines window will appear. Then choose the data range that you want, such as: B2:D4.

excel column sparkline3

4# click Ok button, then let’s see the result.

excel column sparkline4

Create Win/Loss Sparkline

If you want to create or insert Win/Loss Sparklines, just do the following steps:

1# Select one cell or range where you want the sparkline to be placed, such as: Cell E4

2# go to Insert Tab, Click Win/Loss button under Sparklines group.

excel win loss sparkline1

3# the Create Sparklines window will appear. Then choose the data range that you want, such as: B4:D4.

excel win loss sparkline2

4# click Ok button, then let’s see the result.

excel win loss sparkline3

Change Sparkline Type

Assuming the current sparkline type is Line, and if you want to change the sparkline type from Line to Column, just do the following steps:

1# select the line sparkline

change sparkine type1

2# go to DESIGN Tab, click Column button under Type group.

change sparkine type2

3# let’s see the result.

change sparkine type3

Leave a Reply