Excel 2010 Tutorial HD - Sparklines

http://www.GCFLearnFree.org

Sparklines are miniature charts that fit into a single cell. Since they're so compact,
you can place a large number of them in your worksheets. For example, you could place one sparkline on each row to show trends within that row. In this lesson, you will learn how to insert sparklines and change their type and appearance.

Sparklines were introduced in Excel 2010 to be a convenient alternative to charts. Unlike a traditional chart, a sparkline is placed inside a cell, allowing you to easily create a large number of sparklines (for example, one on each row).

Watch the video to learn about creating and modifying sparklines.

There are three different types of sparklines: Line, Column, and Win/Loss. Line and Column work the same as line and column charts. Win/Loss is similar to Column, except it only shows whether each value is positive or negative, instead of how high or low the values are. All three types can display markers at important points, such as the highest and lowest points, to make them easier to read.

Category:

Education

Tags:

• Microsoft Excel
• MS Excel
• tutorials
• spreadsheet
• workbooks
• Excel
• formulas
• how to
• Excel 2010
• computer help
• video tutorials
• Excel tutorials
• Office 2010
• sparklines

[BabaTokky]

A very clear, concise presentation. Thank you.

[gcflearnfree]

@BabaTokky Thanks! Glad we could help! ^Jess

[DocBadwrench]

This is a very clear, concise introduction to sparklines. Well done.

[gcflearnfree]

@DocBadwrench Thanks! Glad we could help! ^Jess

[Ramimcintyre]

Thanks.

[blackprl]

Very nicely done! Thank you!

[poont]

Great video! Thank you