A couple of months ago we received our copy of Office 2010, so it must be about time we start blogging about it! Sparklines is a new Excel feature which we’ve been impressed with. Basically they’re miniature charts that fit into a single Excel cell to allow the user to view individual trends at a glance. A feature such as this is ideal when managing money, e.g. to assess how expenditure for different items has varied over a year.
Here’s how to create Sparklines:
- Click on the ‘Insert’ tab and locate the ‘Sparklines’ box
- Next you must select the type of Sparkline you wish to use by clicking on either Line, Column or Win/Loss
- Finally in the ‘Create Sparklines Box’ you need to select your data range and location range
A neat feature I’m sure you’ll all agree 