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

Related Posts

How to Show or Hide Chart Axis in Excel
show or hide chart axis5

This post will guide you how to show or hide chart Axis in your current worksheet in Excel 2013/2016. How do I show or hide Axes or 3-D chart Axes, Horizontal Axis, Vertical Axis or secondary Vertical Axis in your ...

How to Fill Chart Background or Insert Background Picture into Chart in Excel?
Fill Chart Background or Insert 11

In most excel worksheets we need to add charts to illustrate data clearly. And to make chart noticeable, we can fill chart background with color or insert a picture as background. If you want to know how to implement above ...

How to Insert A Chart with Data lists in Different Range in Excel
Insert A Chart with Data lists in Different Range 19

We can create a chart by quick analysis easily if data source in chart horizontal and axis label is listed in the contiguous range. But the data source is listed in different ranges, the chart created by quick analysis cannot ...

How to Delete All Charts in Excel
Delete All Charts 9

If we inserted a large number of charts and want to delete all of them quickly how can we do? It will spend a lot of time if we delete them one by one in excel. So we need a ...

How to Create Combination Charts in Excel
create combination charts7

This post will guide you how to create combination chart and adding secondary axis in Excel.  How do I create a combination chart so that you can deliver a visual representation for multiple data source. Create Combination Charts Assuming that ...

How to Smooth the Angles of Line Chart in Excel
smooth angles of line chart3

This post will guide you how to smooth the angles of line chart in your current worksheet. How do I make a smooth line chart based on your data in Excel 2013/2016. Smooth the Angles of Line Chart When you ...

How to Copy Chart Format to Another Chart in Excel
copy chart format to another chart9

This post will guide you how to copy formatting from one chart to another chart in Excel. How do I copy chart formatting to anther chart in Excel 2013/2016. Copy Chart Formatting with Paste Special Copy Chart Formatting with Short ...

How to Reverse Axis Order in Excel Chart
reverse axis orader3

This post will guide you how to reverse the order of a chart Axis in your current worksheet in Excel 2013/2016. Assuming that you have created a column chart based on your data in your worksheet, and you may want ...

How to Create a Stock Chart (Open-High-Low-Close) in Excel
create stock chart 4

This post will guide you how to create a stock chart to present your stock’s data in an easy to read manner in your current worksheet in Excel. How do I create a High-Low-Close Stock market chart based on your ...

How to Create a Chart with Two-level Axis labels in Excel
create chart with two level axis14

This post will guide you how to create a column chart with two-level Axis labels based on your original data in Excel. How do I create a Two-level X axis labels in your Chart with Pivot table in Excel 2013/2016. ...

Sidebar