About MrExcel
Consulting Services
Learn Excel Resources
Challenge of the Month
MrExcel Seminars

Message Board

MrExcel Store


Sparklines and Sparkbars - Tiny Charts for Excel

Amber MacArthur, Bill Jelen, Leo LaPorte, Andy Walker on the set of Call for Help on TechTV Canada.

The tip in this show is from Learn Excel from MrExcel.

In his book, Beautiful Evidence, Edward Tufte introduced the concept of Sparklines. These are tiny, word-sized graphics that can convey a trendline over time.

These charts are great for executive dashboards or when you need to pack a lot of information into a small space.

In today's episode, I showed a cool product called the Bissantz SparkMaker. This product comes in a free variety and a premium version. With the free version, you can create sparklines in Excel. You can try out the pro version for thirty days. The pro version offers these features:
  • SparkBars:

  • Use of colors:

  • The ability to create sparklines as graphic images or as Excel function. The graphic image allows you to share the workbook with someone who does not have the SparkMaker add-in.
  • The ability to create sparklines through a dialog box. Here, you can specify advanced features such as color, rotation, etc.
Click to check out SparkMaker

For the BEST TV show on technology, check out Call for Help.

This tip was originally published on December 25, 2006 and aired on TechTV in Canada and Australia on December 25, 2006.

The permanent URL for this page is

If you are looking for show notes from another episode, visit my complete list of TechTV appearances. Consulting can be hired to implement this concept, or many other cool applications, with your data. provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.


Excel is a registered trademark of the Microsoft® Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.

All contents Copyright 1998-2008 by MrExcel Consulting.