Windows Guides Feed

Excel 2010: Sparklines

By on October 25, 2011 Comments Off

Excel Excel 2010: SparklinesExcel 2010, did not come with too may new features. It’s hard to come up with  ideas on how to improve something that is already a great product, I’m sure. But there was one new thing I’ve found quite useful: Sparklines.

Sparklines – What’s that ?

 

sparklines 500x218 Excel 2010: SparklinesI thought you’d say that. Well, let’s for argument sake say you did. In short, Sparklines are tiny diagrams or charts that you can insert into your worksheet at the end of a row or column to project trends or compare statistics. Each Sparkline is so small that it takes up no space at all. One Cell is all it takes, making it a brilliant visual help to monitor your numbers.

One usage that comes to mind is to monitor your sales progress during a month, week, quarter. Or, maybe if you have an Excel sheet to monitor your stock options, you can quickly see how they are doing suing small Sparklines.

Sparklines are located in the middle of the Insert Ribbon with three standard lines to choose from. Highlight the area you would like to monitor and choose your Sparkline of choice. I’m sure you’ll wonder, however you managed without.



 Excel 2010: Sparklines

About Thomas

Computer geek from the age of 7, which amounts to 30 years of computer experience. From the early days (when every computer company had their own OS) of DOS, Windows 1.0 through Seven...

Free PC tips by email

Search Windows Guides




Comments

Comments are closed. Join the conversation at Windows Forums.


Computer tips in your inbox
Sign up for the Windows Guides newsletter to get PC tips and access to free Windows books (More details)

Enter your email address:
 

Popular Guides

See which sites have been visited on your PC (even if private browsing mode is used)

Create a Windows 7 System Repair Disc

Best Free Anti-malware

Hibernate vs. Sleep vs. Shut-Down

i3, i5, and i7; Dual, Quad, Hexa Core Processors. How to they Differ?

Intel's Ivy Bridge Processor: new Features

Submit Your Tip
Submit your computer tip to us; receive full credit for all published tips

Windows Guides on Facebook