An Opened Mind | Homepage
MS Excel Sparklines Made Simple: For Beginners

MS Excel Sparklines Made Simple: For Beginners

🕔22.Jul 2018

The following Chapter is from my upcoming eBook on Excel Charts, presented here for online Excel tutorial. In this online Excel tutorial, we are going to focus on Charts of Excel. The data sample is available for download only for paid members of this website. This articles is written to help you learn excel online.

How to work with Sparklines:
For this chapter, we are going to use Data Sample 3. The data contains sales report of some books of a Book Store for consecutive months in 2014. The data can be used by anyone having bookshop or coffee shop or running any kind of local store to graph their sales data.
Sparklines are small in nature which can fit into a single cell of Excel worksheet. One of the advantages of their tiny nature is that they can be fitted just beside the corresponding data which gives very much clear visual representation of data. Sparklines are normally used to see the trends like increase or decrease in sales etc.

How to create Sparkline:
1. We are going to create Sparkline of the Sales fig. for four consecutive months for the first book in the Wroksheet: A Tale of Two Cities. Select the data first from C6 to F6.
2. Then, go to Insert tab and just beside the Charts group, there is Sparklines group. Select Line in the Sparklines group.

3. Then a dialogue box called Create Sparklines appear showing the data range, which we already had selected for the first book, as C6:F6.
4. In the same dialogue box, there is another field called Location Range. For this, we need to select the empty cell just beside the data of December, i.e G6. This will create the Sparkline in G6 cell to help us visualize the data better
5. Select the Location Range by clicking on the box and then $G$6 appears in the Location Range field. Click OK. The Sparkline for the sales fig. of the book A Tale of Two Cities appears in the cell G6.

6. Now, click on the fill handle that appears in the G6 box and pull it downwards till the G9 cell so that all the cells get filled by the Sparklines for the corresponding books.
See the Sparklines for each cell:

From the above fig., we can get an idea regarding the performance of the books in respect of their sales trend. For eg., the first book, A Tale of Two Cities show downward sales trend for the last two remaining months of 2014. Similarly, the last one, Robinson Crusoe, had started from downward trend but then it was selling well for the last couple of months compared to its downward trend in the month of September.

Sparklines can be made more interesting and attractive as well as meaningful which we are going to see next.

Hope you have learned as well as enjoyed this online Excel tutorial. If you like this Excel tutorial, feel free to buy our eBook to learn Excel online.

Download Sample data:
Data Sample 3

About Author

AnOpenedMind.com Staff

AnOpenedMind.com Staff

A down-to-earth person sharing knowledge with the world! Believes in global brotherhood, freedom of speech, food and education for all!!

View More Articles 🌎View Website Send an E-Mail

Join 10,000+ Followers On Twitter

Weekly Good Read

Search

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Follow

Get the latest posts delivered to your mailbox:

error: Content is protected !!