How to work with Sparklines in Excel

In this tutorial, we will teach you how to insert Spark lines in Excel. Sparklines in Excel help you express your data graphically. There are several types of sparklines such as lines, columns or win/loss. In lines, you can view the ups and downs, the peaks and slumps while in win/loss the negative points will be shown in a different color. We will also show you how to change the styles on these sparklines.


Step # 1 – Insert Sparklines

Go to the insert tab and from the “sparklines” group, click on the “line” button. A small box will appear; select the “data range” and then select the column for the “location range” where the sparklines will appear.
You can easily increase the size of the lines by stretching your column width.

Apply Sparklines in Excel

Step # 2 – Change Marker Color

From the “design” tab, click on the “marker color” button and go to “markers” and from there choose a color for the markers. All the points will be highlighted.

Choose Marker Color

Step # 3 – Display High & Low Points

If you want to see the high and low points, you can check their respective boxes which are located in the “show” group. Next, you can choose the “style” of the lines. Click on the downward arrow and from the various options that appear in front of you, choose any one of them. Likewise, if you want to see the negative points, tick its respective checkbox.

Show High & Low Points

Step # 4 – Apply Win/Loss Structure

From the “type” group, you can change the type of sparklines. Click on the “Win/Loss” button and it will show you bars with the negative points highlighted in another color.

Change type to Win/Loss

Step # 5 – Show Axis

If you want to see the axis, click on the “axis” button and select the “show axis” option.

View Axis