Sparklines: Use tiny charts to show data trends

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

As you look at rows and rows of data, sometimes it’s hard to immediately make sense of it. Add tiny charts called sparklines next to data to give readers a picture of what the data means, making it easy to spot patterns and trends.


After completing this course you will be able to:

  • Add sparklines to spreadsheet cells.

  • Determine which kind of sparkline to use.

  • Change sparkline styles.

  • Clear sparklines from spreadsheet cells.

Download this course

Offline version (19.6 MB)


We’re sorry, the practice session is not available.

Quick reference card

See the quick reference card for a brief, printable reminder of the key points in this course.

See more courses on Microsoft Office Training.

Was this information helpful?

How can we improve it?

How can we improve it?

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!