How to Change Sparkline Style in Excel (4 Suitable Examples)

Get FREE Advanced Excel Exercises with Solutions!

The random Sparkline Style generated can be quite normal and lack clarity. We can modify the styles to alleviate these problems. If you are curious to learn about Modifying Sparkline Style in Excel, this article may come in handy for you. In this article, we are going to show how you can change the Sparkline Style in Excel with elaborate explanations.


Steps to Add Sparklines in Excel

Before we delve into modifying the Sparklines, we need to create the Sparklines first

Basically, there are three different types of Sparklines such as Line Sparkline, Column Sparkline, and Win/Loss Sparkline. Each one of them will be created here.

Steps

  • In order to add a Sparkline, we need to select cell G5 first.
  • Then go to Insert tab > Sparklines group.
  • After that, click on the Line icon.

Add Sparklines in Excel to Change Sparkline Style in Excel

  • Then a dialog box will appear asking for the range of cells with which the Sparkline will be added.
  • Select the range of cells C5:F5 in the Choose the data that you want range box in that dialog box.
  • Select G5 in the Choose where you want the sparklines to be placed.
  • Click OK after this.

  • Then you will notice that there is a Line type Sparkline in cell G5.

  • Then drag the Fill Handle to cell G14.

  • Then go to Insert tab > Sparklines group again.
  • After that, click on the Column icon.

Add Sparklines in Excel to Change Sparkline Style in Excel

  • Then a dialog box will appear asking for the range of cells with which the Sparkline will be added
  • Select the range of cells C5:F5 in the Choose the data that you want range box in that dialog box.
  • Select H5 in the Choose where you want the sparklines to be placed.
  • Click OK after this.

  • Then you will notice that there is a Column type Sparkline in cell H5.

Add Sparklines in Excel to Change Sparkline Style in Excel

  • Then drag the Fill Handle to cell H14.

  • Then go to Insert tab > Sparklines group again.
  • After that, click on the Win/Loss icon.

  • Then a dialog box will appear asking for the range of cells with which the Sparkline will be added
  • Select the range of cells C5:F5 in the Choose the data that you want range box in that dialog box.
  • Select I5 in the Choose where you want the sparklines to be placed.
  • Click OK after this.

  • Then you will notice that there is a Win/Loss type Sparkline in cell I5.

  • Then drag the Fill Handle to cell I14.

Now we created our preliminary dataset of the Sparklines, but it does not have any kind of Axis.

To add an Axis, select the range of cells H5:I14.

  • And then from the Sparkline, click on the Axis, and then from the drop-down menu, click on the Show Axis.

  • After that, you will notice that the Axis has now been added in the Column and Win/Loss type Sparklines.

Add Sparklines in Excel to Change Sparkline Style in Excel


How to Change Sparkline Style in Excel: 4 Suitable Examples

We will use the below-created dataset in the previous steps. We have the salespersons’ name and their growth rate over the quarters in a year. We also have three different types of Sparklines that are already created, and Axis’s has also been added to the sheet.


1. Changing Sparkline Style

To avoid the hassle, we can ignore all the small, tiny, detailed things we need to do to change the Sparkline Styles. and choose a variety of Default Styles already in the Sparkline menu. Those default styles are quite useful and can save a lot of time.

Steps

  • By default, the Sparklines are grouped, all three of them.
  • So, select any Line type Sparkline in the range of cell G5:G14.
  • Then from the Sparkline tab, choose any default Sparkline Style in the Style group.

  • Then do the same for the Column.
  • So, select any Column type Sparkline in the range of cell H5:H14.
  • Then from the Sparkline tab, choose any default Sparkline Style in the Style group.

  • Then do the same for the Win/Loss.
  • So, select any Win/Loss type Sparkline in the range of cell I5:I14.
  • Then from the Sparkline tab, choose any default Sparkline Style in the Style group.


2. Changing Sparkline Color

To distinguish the Sparkline types and for better visibility, changing the color of the Sparklines is a good option.

Steps

  • In the beginning, click on the already created Line type Sparkline.
  • And then from the Sparkline tab, click on the Sparkline Color.
  • From the drop-down menu, click on your preferred color.

Changing Sparkline Colorto Change Sparkline Style in Excel

  • Then you will notice that the color of the Sparkline has now changed to your preferred color.
  • Now repeat the same process for the remaining two types of Sparkline types.
  • In the beginning, click on the already created Column type Sparkline.
  • And then from the Sparkline tab, click on the Sparkline Color.
  • From the drop-down menu, click on your preferred color.

Changing Sparkline Colorto Change Sparkline Style in Excel

  • Then you will notice that the color of the Sparkline has now changed to your preferred color.
  • Now repeat the same process for the remaining Win/Loss types of the Sparkline.
  • In the beginning, click on the already created Win/Loss type Sparkline.
  • And then from the Sparkline tab, click on the Sparkline Color.
  • From the drop-down menu, click on your preferred color.

Changing Sparkline Colorto Change Sparkline Style in Excel


3. Changing Marker Color

A marker is used to mark the important points in a Sparkline. Highlighting them with a different color from the Line color is a better way to improve the visibility and clarity of the Sparkline.

Steps

  • The markers mark the significant points in a Sparkline.
  • In order to change the color of it, we should add a marker first.
  • To do this, we need to click on the Line type Sparkline in the sheet and go to the Sparkline tab > Show group.
  • Then in the show group, check the Marker box.
  • Right after this, you will notice that there are markers in the Sparkline in the range of cells G5:G14.
  • Now go to Sparkline tab > Marker Color.
  • Then from the drop-down menu, click on the Markers and then choose your preferred color of marker. Here we choose Red.

Changing Marker Color to Change Sparkline Style in Excel

  • Repeat the same process for the Column type Sparkline.
  • To do this, we need to click on the Column type Sparkline in the sheet, and go to the Sparkline tab > Show group.
  • Then in the show group, check the Negative box.
  • Right after this, you will notice that there are markers in the Sparkline in the range of cells H5:H14.
  • Now go to Sparkline tab > Marker Color.
  • Then from the drop-down menu, click on the Markers and then choose your preferred color of marker. Here we choose Red.

  • Repeat the same process for the Win/Loss type Sparkline.
  • To do this, we need to click on the Win/Loss type Sparkline in the sheet and go to the Sparkline tab > Show group.
  • Then in the show group, check the Negative box.
  • Right after this, you will notice that there are markers in the Sparkline in the range of cells I5:I14.
  • Now go to Sparkline tab > Marker Color.
  • Then from the drop-down menu, click on the Markers and then choose your preferred color of marker. Here we choose Green.

Changing Marker Color to Change Sparkline Style in Excel


4. Changing Line Weight

To improve the visibility of the Sparkline, we can increase the thickness of the Sparklines.

Steps

  • In order to do this, select the Line type Sparkline in the sheet, and then from the Sparkline tab, click on the Sparkline Color.
  • Then from the drop-down menu, click on Weight below the color pallet.
  • You will notice that the Line weight is only 0.5 pt.
  • We need to increase that to 1.5 pt.

  • Scroll down and click on the 1.5 pt.
  • Right after you select the 1.5pt, we can see that the Line is now immediately thicker than the previous one.

And by changing the sparkline weight we can change the sparkline style in Excel.


Download Practice Workbook

Download this practice workbook below.


Conclusion

Here, we have answered the question of how you can change the Sparkline Style in Excel with 4 different examples.

For this problem, a workbook is available for download where you can practice these methods.

Feel free to ask any questions or feedback through the comment section.


Related Articles


<< Go Back to Excel Sparklines | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Rubayed Razib Suprov
Rubayed Razib Suprov

Rubayed Razib, holding a BSC degree in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, serves as a devoted member of the ExcelDemy project. He has contributed significantly by authoring numerous articles and showcasing proficiency in VBA. Razib efficiently automates Excel challenges using VBA macros and actively participates in the ExcelDemy forum, providing valuable solutions for user interface challenges. Apart from creating Excel tutorials, he is interested in Data Analysis with MS Excel,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo