Rubayed Razib Suprov
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.
Download Practice Workbook
Download this practice workbook below.
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, Line, Column, and Win/Loss. 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 then, click on the Line 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.
- And 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 then, click on the Column 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.
- And 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.
- Then drag the Fill Handle to cell H14.
- Then go to Insert tab > Sparklines group again.
- After then, 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.
- And 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 then, you will notice that the Axis has now been added in the Column and Win/Loss type Sparklines.
Read More: How to Use Sparklines in Excel (Create and Customize)
4 Suitable Examples to Change Sparkline Style in Excel
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. And 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.
- Then you will notice that the color of the Sparkline is now changed to your preferred color.
- Now repeat the same process for the remaining two types of the 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.
- Then you will notice that the color of the Sparkline is 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.
Read More: How to Change Sparkline Color in Excel (with Detailed Steps)
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 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.
- 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 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 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.
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.
Conclusion
Here, we have answered the question” 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. Any suggestion for the betterment of the Exceldemy community will be highly appreciable.
