How to use Sparklines in Excel 2010

Posted on November 27, 2009 at 5:28 am

Microsoft Excel 2010 makes it possible to analyze information in more ways than ever before. The new version will allow users to track and highlight important data trends with new data analysis and visualization tools. Sparklines are mini-charts that you could place inside cells so that you can view the data and the chart on the same table.

In this post I will show you how to insert Sparkline charts in an Excel spreadsheet.  Begin with a regular spreadsheet document – in the example below I used the sales report template from Excel 2010 but any Excel sheet with tabular numeric data could also be used.

image

Select the cells where you want the sparklines to appear. Put it at the side of the table for easier viewing.

image

Click the Insert menu from the ribbon then choose “column” under the Sparklines group.

image

Select or enter the range of cells that will be the source of the data for the charts.

image

The charts should appear at the side of the table.

image

At a glance you could now see trends of growth or decline.  For example, the ones in circles have growing trend:

image

With proper use of Sparklines, data analysis is quicker and more direct to the point.  You will also have a simpler view of information without having a busy chart hovering on top of your sheet.  Make sure to visit us regularly for more Office 2010 tips!

Ben Carigtan shows you how it’s done!

» Filed Under MS Office Tips

Related Posts

Comments

4 Responses to “How to use Sparklines in Excel 2010”

  1. Techadictos said on : November 27th, 2009 at 1:18 pm

    nice tip, yesterday I Spoke of Office 2010 on my blog, thanks for the Excel Sparklines trick!


  2. Andreas said on : December 7th, 2009 at 2:27 pm

    For sparklines that work with older Excel version (Excel 2000, XP, 2003 and 2007) have a look on MicroCharts

    bonavistasystems.com

    Andreas


  3. Boudreaux said on : December 8th, 2009 at 11:30 am

    Wow! Before this article, I had never heard of Sparklines! That is so utterly awesome! I am now the Excel guru at my office! Thanks!


  4. Rendi said on : March 13th, 2010 at 2:32 am

    Is there anyway to get sparklines in Excel 2007? Like an add-on or macro or plugin of some sort? Thanks!


Please post your comments/suggestions!