web 2.0


Excel 2010: Sparklines

VERSION: 14.0.4006.1110

Excel 2010 now comes with sparklines. In the past, we needed third party software in order to work with these little creatures. They are now native to Excel. Here’s a look at the Excel 2010 sparklines:


Figure 1: Line Sparkline

In the above scenario, we have a line sparkline, but Excel 2010 comes with some others such as “column sparkline” and “win/loss sparkline” shown below for the same dataset:


Figure 2: Column Sparkline with high points (light color)

If we consider the conditional formatting data bars introduced in Excel 2007, this is a great addition to Excel 2010.

Most importantly: it is very easy to use. Under the “Insert” tab, close to the “Charts” group you will find the “Sparklines” group. The shaded area in the picture below shows the sparkline location:


Figure 3: Sparkline group under the Insert tab

Once the sparkline is inserted, you can quickly change style, type, show/hide low/high points, etc:


Figure 4: Sparkline extensibility tab and Sparkline Design tab

Tags: , , ,

Microsoft Excel | Microsoft Office 2010

Comments

Andreas Germany, on 7/23/2009 5:32:00 AM Said:

Andreas

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

http://www.bonavistasystems.com

Andreas

Fabrice France, on 8/6/2009 1:25:56 PM Said:

Fabrice

I think the guys at MSF are just re-inventing the wheel.

First thing they should have done is analyse the existing sparklines products like Andreas' Microcharts.

or like the free opensource http://sparklines-excel.blogspot.com/

Many key options are missing (reference line, Normality zone, simplified scale...)

Maybe for XL 2013...

business-intelligence.kdejonge.net , on 3/19/2010 10:36:35 AM Said:

pingback

Pingback from business-intelligence.kdejonge.net

Kasper de Jonge BI Blog » PowerPivot and Sparklines .. the easy way

powerpivotpro.com , on 3/30/2010 11:55:42 AM Said:

pingback

Pingback from powerpivotpro.com

PowerPivot and Sparklines .. the easy way «  PowerPivotPro

powerpivotpro.com , on 3/30/2010 12:49:18 PM Said:

pingback

Pingback from powerpivotpro.com

PowerPivot and Sparklines .. the easy way «  PowerPivotPro

blogs.zdnet.com , on 6/15/2010 9:11:21 AM Said:

pingback

Pingback from blogs.zdnet.com

Microsoft launches $80 million Office 2010 ad campaign | ZDNet

windows-7.com.ua , on 6/16/2010 4:38:50 AM Said:

pingback

Pingback from windows-7.com.ua

Стартовали продажи Office 2010 | Блог о Windows 7

websiteofthestate.interactiveinfonet.info , on 8/14/2010 12:20:28 AM Said:

pingback

Pingback from websiteofthestate.interactiveinfonet.info

Web site of the state - State web - State of south dakota web site

anniversaryrings.interactiveinfonet.info , on 9/6/2010 1:29:57 PM Said:

pingback

Pingback from anniversaryrings.interactiveinfonet.info

Anniversary diamond engagement ring - Diamond engagement - Anniversary rings

birthdayverses.interactiveinfonet.info , on 9/14/2010 10:35:19 PM Said:

pingback

Pingback from birthdayverses.interactiveinfonet.info

Birthday daughter in law verse - Birthday daughter - Birthday verses

caicosturks.bestproinfo.in , on 2/26/2011 6:37:33 PM Said:

pingback

Pingback from caicosturks.bestproinfo.in

Turks and caicos ocean club west

darkundereye.com , on 3/10/2011 7:16:15 PM Said:

pingback

Pingback from darkundereye.com

Dark Under Eye

ballocapesso.allergiesaid.com , on 12/16/2011 12:59:04 AM Said:

pingback

Pingback from ballocapesso.allergiesaid.com

Sparklines excel | Ballocapesso

bgmiami.yoursexualaids.net , on 6/15/2012 12:11:08 AM Said:

pingback

Pingback from bgmiami.yoursexualaids.net

Excel sparklines | Bgmiami

siteduct.com , on 12/7/2012 11:01:49 AM Said:

pingback

Pingback from siteduct.com

Trackback Software

followliker.com , on 8/2/2013 9:52:39 AM Said:

pingback

Pingback from followliker.com

twitter marketing tool

alexatrafficracer.org , on 10/8/2013 7:10:22 AM Said:

pingback

Pingback from alexatrafficracer.org

Extended Living Spaces

Comments are closed