Office 2010 (from 2003) : Excel : Sparklines

Introduce Me


NEW_Mouse_Head_Lightbulb2.jpgSparklines

Sparklines are miniature charts that fit within a cell to summarise data trends.

They are not objects, but tiny charts embedded within the background of a cell enabling trends to be displayed in a small amount of space. This makes them ideal to show a mini snapshot of data.

 

Tell Me


Creating Sparklines:

  1. Click the empty cell into which the sparkline will be placed
  2. Select the Insert tab
  3. Choose the type of sparkline to be used (within the Sparklines group)

    2010whatsnew2003xlssparkline01.jpg
  4. Click the Data Range Collapse Dialog box

    2010whatsnew2003xlssparkline02.jpg
  5. Select the range of cells that contain the sparkline data
  6. Press Enter
  7. Click OK


Tell Me More


Once a sparkline has been created, the Design tab becomes available from which further customisations can be made.

Customising Sparklines:

  1. Click the sparkline
  2. Select the Design tab
  3. Use the options within the Styles group to apply the colours and styles required

    2010whatsnew2003xlssparkline03.jpg


Show Me



Tip


Because sparklines are embedded into the background, text can be entered directly into the cell and formatted as normal.


Let Me Try


Here is an exercise for you to try out creating sparklines for yourself.

2010 Excel - Sparklines

If the "OPEN" option does not show you all icons you'd expect in the application, use the "SAVE" option.

1aletmetry


Help Me

NEW_Mouse_Head_Glasses2.jpgRemember to put your new skills into practice as soon as possible.

Learn a little each day to improve your knowledge and skills

 

 
 

What's New

Blended Migration Solutions

Create your own courses

Eureka Moments

My Bite Size Learning System
-
+
4
Login

My Bite Size Login