Excel 2010 – Sparklines

Graph is an effective way to present large amount of data.  However, data driven graph can also be quite large in older versions of Microsoft Excel, so it is not easy to post multiple graphs on 1 single piece of paper.  Microsoft Excel 2010 has implemented Sparklines to solve this problem. Sparklines is "intense, simple, word-sized graphics", its inventor Edward Tufte describes them in his book Beautiful Evidence.

alt

You can see from the above example, the current sales number plus sparklines that indicated 1 year trend of the sales pattern.  Each sparkline takes up a cell and it is not floating on the grid like chart does.  It does not give you details number but it adds context and meaning to the number next to it. Below you can find a few more examples on how sparklines can present extra information. altalt

Creating sparklines is quite easy.  First, you insert a new column where you want to place your sparklines.

alt

And then you go to the insert tab on the ribbon and choose the type of Sparklines that you want to inset into your column. alt

You define the Data Range and Location Range in the Create Sparklines dialogue and click OK button.

alt

Now, you have your first sparklines.

alt

You can format you sparklines, e.g. highlight the high and low points on the sparklines.  When you select the sparklines, you would see a sparkline contextual tab in the ribbon.

alt

You can highlight high / low points by specifying their color.

alt

Your sparklines would then have the new format.

alt

Isn’t it easy?  You can download a copy of Microsoft Office 2010 Beta and starting experiencing all the new features including Sparklines.

Andrew Chan is the owner and founder of ALG Inc.

We help you to make better and faster decisions!


About Andrew Chan
Andrew Chan is an Business Consultant who gives you accurate, consistent and timely information so that you can make better and faster decisions. He is an Associate of Society of Actuaries with over 20 years of IT experience. Apart from strong analytical skills and proven technical background, he was also a former system director at Manulife who had extensive project management experience. If you are looking for someone to gather, consolidate, validate, visualize and analyze data, look no further! Andrew can provide the most cost effective business analytics solution so that you can explore, optimize, predict and visualize your business. Don’t guess on any decision, no matter it is finance, operation, marketing or sales! Always ask for evidence!

3 Responses to Excel 2010 – Sparklines

  1. Pingback: Microsoft PowerPivot for Excel 2010 – Adding Slicer | Technologies and your business

  2. Pingback: Is Excel our only option? « Technologies and your business

  3. Pingback: Wish you a Merry Christmas and a Happy Analytics Year! « Technologies and your business

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: