Sparklines in Excel: Simplicity Itself

Sometimes the best ideas are the simplest ones. Sparklines are little, word-like graphics. A sparkline can shows a single time-series or the occurance of events. The idea is that as you can pick up the gist of the data in the flick of an eye. This lets you say things like:

The New Jersey Nets have been streaky all year while the Boston Celtics have been the picture of consistency--consistent mediocrity.

A note on interpretation: green upward whiskers are wins, red down whiskers are losses. So how can ordinary business folks make these things? Until now, sparklines have been the domain of programmers and graphic artists.

Thankfully, Bissantz, a German company, had an elegant idea. The created a set of special sparkline fonts and an easy to use tool that you can use to build sparklines in Excel using their fonts. The tool looks like this.

Sample sparklines look like this:

It works in Excel and it really is fun and easy.

If you want to learn more about sparklines and see some beautiful examples; the canonical page for sparkline theory and discussion is here. Edward Tufte provides a chapter on sparklines from his newest book followed by a back an forth discussion with practitioners in the field. Lots of great examples!

This work is licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 United States License. All source code is released under a BSD License unless otherwise specified.

1 comment


September 29, 2008
Fabrice said:

Thanks your inspiring blog,

Here is a free alternative to Bissantz Sparkmaker and Bonavista MicroChart :
Sparklines for Excel --> http://sparklines-excel.blogspot.com/

It includes 11 types of sparklines ... and more to come

Regards

Your name

Email (optional, will not be shared)

Type the word "juice" (required to confuse the spammers)

Your comment


Add a comment