Skip to content


Easily Create Sparklines with PHD Sparkline Maker

Posted in Tips & Tricks.
Easily Create Sparklines with PHD Sparkline Maker

Sparklines is introduced in Microsoft Excel 2010 to visualize data using chart wihin the cell. Sparklines is a wondful feature for data analysis. However, you can not directly make Sparklines chart in early version of Microsoft Excel.
However, you can get an Excel Sparkline Template named PHD Sparkline Maker to obtain Sparklines easily without macros or add-ins.

Now download Excel 2007 version of sparkline template and Excel 2003 version can be found here.

Easily Create Sparklines with PHD Sparkline Maker 002

Open sparkline-mkr.xlsx and just enter your own data and sparkline will be automatically generated. Then copy the sparkline(s) and paste them as images wherever you want. That is “Enter Data->Copy the Spark-line->Paste it as a Picture”.

Easily Create Sparklines with PHD Sparkline Maker 003

Enjoy your Sparklines.

For more information about PHD Sparkline Maker, please read this article and to learn more about Sparklines, read this article from Microsoft Excel 2010 blog. Also there is a step-by-step tutorial to show beautiful Sparklines effects in Excel 2010.

PS: There is a useful add-in to create Sparklines in-cell charts and it is Sparklines for Microsoft Excel.

Tagged with , , , , .


0 Responses

Stay in touch with the conversation, subscribe to the RSS feed for comments on this post.



Some HTML is OK

or, reply to this post via trackback.

*
To prove you're a person (not a spam script), type the security word shown in the picture. Click on the picture to hear an audio file of the word.
Click to hear an audio file of the anti-spam word