Sparkline Tools -> Design->Type -> Column

Exam 77-882: Microsoft Excel 2010 Core

6. Presenting Data Visually

6.4. Apply Sparklines: Format a Sparkline

Sparkline: Change Type

There are three types of Sparklines: Line, Column, Win/Loss. You can change the Type with the Sparkline Ribbon if you wish.


Before You Begin: Click once on the Sparkline so that it is selected. The Sparkline Tools should be available.


3. Try This: Change the Type

Go to Sparkline Tools -> Design.

Go to Type->Column.



What Do You See? The Sparkline is a very tiny chart. The Column type may be easier to see the trends compared to the Line type, depending on the data.

Keep going...