How to use Sparklines in Microsoft® Excel 2010
A picture is worth a thousand words and in this case, a chart is worth a thousand figures! Well, if you are trying to figure out what exactly this means let us tell you that we are talking about Sparklines in Microsoft Excel 2010. This new tool has been added to the latest Microsoft Excel edition – Microsoft Excel 2010 – to enable a user to highlight the upward and downward trend of figures in a spreadsheet. Although by looking at the numbers that you enter in the spreadsheet, your viewer will surely get enough idea about the trend, however, by simply using this tool, you can make your viewer get the entire picture at just a glance. It is a great tool to represent your data visually. It is simple, easy to use, and definitely effective.
Now that you know about Sparklines, let us tell you how you could use one. Depending upon your requirement, you could use either one Sparkline or several Sparklines to highlight your data. Here’s how you can use this feature in four easy steps.
- Select one cell/ group of cells to insert the Sparkline
- Go to the ‘Insert’ tab and locate ‘Sparklines group’
- Choose from the three available options – Line, Column, Win/Loss
- Identify and type the range of cells, the data of which you want the Sparkline to demonstrate
Tip: You can use the Design tab to create and format Sparklines in your spreadsheet. You can also customize Sparklines to create better impact.
Image by jurvetson