How to Create Column Sparklines in Excel (3 Suitable Examples)

Sparklines are a short version of an Excel column chart. They are usually used to show the data pattern row-wise. The data changing pattern is displayed in an Excel cell. In this article, we will demonstrate three quick examples of how to create column sparklines in Excel. If you are curious about it, download our practice workbook and follow us.


Download Practice Workbook

Download this practice workbook for practice while you are reading this article.


3 Suitable Examples to Create Column Sparklines in Excel

To demonstrate the examples, we will consider a dataset of 10 entities and their corresponding values for the first quarter of any year. The data for the months January, February, and March are in columns C, D, and E, respectively.


1. Column Sparklines for Positive Values

In this example, we will consider the income of 10 employees for the first three months of a year. The name of the employees is in the range of cells B5:B14. The salary for the months of January, February, and March, are in the range of cells C5:C14, D5:D14, and E5:E14, respectively. We are going to show the column sparklines in column F.

The steps to complete the task are given as follows:

๐Ÿ“Œ Steps:

  • First of all, select the range of cells C5:E5.
  • Now, in the Insert tab, select the Column command from the Sparklines group.

Create Column Sparklines for Positive Values

  • As a result, a small dialog box called Create Sparklines will appear.
  • Our selected cell range is in the data range field of that dialog box.
  • After that, choose your desired location, where you want to display the column sparkline. We select F5 to show our sparkline.
  • Click OK.

Create Column Sparklines for Positive Values

  • You will see the column sparklines inside cell F5.

Create Column Sparklines for Positive Values

  • Now, drag the Fill Handle icon to copy the sparklines feature up to cell F14.

Create Column Sparklines for Positive Values

  • Our task is completed.

Thus, we can say that our working procedure worked perfectly, and we were able to create column sparklines in Excel.

๐Ÿ’ฌ Things You Should Know

In a column sparklines, the value of the vertical axis starts from the lowest value. As a result, every lowest value in a row is close to zero.

Sparklines is a light version of an Excel chart for showing the data changing pattern row-wise. It will just provide you with a preliminary idea about the data changing pattern.


2. Column Sparklines for Zero and Empty Values

To demonstrate this example, we are going to consider the previous dataset. However, in this case, we have 2 empty cells at E6 and C10. Moreover, we take 2 cells with 0 values at the position of D8 and E13. We will display the column sparklines in column F.

The procedure to complete the task is given below step by step:

๐Ÿ“Œ Steps:

  • First, select the range of cells C5:E5.
  • Then, in the Insert tab, select the Column command from the Sparklines group.

Create Column Sparklines for Zero & Empty Values

  • As a result, a small dialog box called Create Sparklines will appear.
  • Now, choose your desired location, where you want to display the column sparkline. We select F5 to show our sparkline.
  • Finally, click OK.

Create Column Sparklines for Zero & Empty Values

  • You will see the column sparklines inside cell F5.

Create Column Sparklines for Zero & Empty Values

  • After that, drag the Fill Handle icon to copy the sparklines feature up to cell F14.

Create Column Sparklines for Zero & Empty Values

  • Our task is finished.

At last, we can say that our working procedure worked precisely, and we were able to create column sparklines in Excel.

๐Ÿ” Interpretation of the Sparklines

You may notice that the column sparklines pattern at the rows of 0 value and empty cells are not similar to the other rows.

If we consider row 6, there is an empty cell that remains at the position of E6. As a result, Excel is showing us a gap in the corresponding location in the column sparklines. Moreover, it considers the lowest value of that as the starting point of the vertical axis. So, that value is close to the base.

On the other hand, row 8 has a 0 value cell at the position of D8. In this case, Excel considers the 0 value as the lowest value of this row. As a result, this value is close to the base, and the other values are shown with respect to this value.


3. Column Sparklines for Real Numbers

In our previous datasets, we considered all the positive values. However, in this dataset, we are taking both positive and negative data. For that, we take the temperature of 10 different states of the US for the first three months of a year. The name of the states is in column B. The temperature of the month of January, February, and March are in columns C, D, and E, respectively. We will show the column sparklines in column F.

The steps to complete the task are given below:

๐Ÿ“Œ Steps:

  • At first, select the range of cells C6:E6.
  • Now, in the Insert tab, select the Column command from the Sparklines group.

Create Column Sparklines for Real Numbers

  • As a result, a small dialog box called Create Sparklines will appear.
  • Then, choose your desired location, where you want to display the column sparkline. We select F6 to show our sparkline.
  • Finally, click OK.

  • You will see the column sparklines inside cell F6.

Create Column Sparklines for Real Numbers

  • After that, drag the Fill Handle icon to copy the sparklines feature up to cell F15.

Create Column Sparklines for Real Numbers

  • Excel will show a downward column for the negative value.
  • To visualize them more effectively, go to the Sparkline tab and click the drop-down arrow of the Axis command.
  • Then, check the Show Axis option,

Create Column Sparklines for Real Numbers

  • You will see a horizontal axis through the column sparklines, and our task is finished.

Create Column Sparklines for Real Numbers

Finally, we can say that our working procedure worked successfully, and we were able to create column sparklines in Excel.


Conclusion

Thatโ€™s the end of this article. I hope that this article will be helpful for you and you will be able to create column sparklines in Excel. Please share any further queries or recommendations with us in the comments section below if you have any further questions or recommendations.

Donโ€™t forget to check our website ExcelDemy for several Excel-related problems and solutions. Keep learning new methods and keep growing!

Soumik Dutta
We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo