Microsoft Sparklines

This month I am teaching my classes how to use Microsoft Excel. One really cool graphic chart feature is called Sparklines. A sparkline is a tiny chart in a worksheet cell that provides a visual representation of data (Source: Support.Office.com).

By selecting the data you want to examine and creating a sparkline, this can indicate possible trends in your data. There are 3 types of sparklines you can choose from such as line, column or win/loss. You can format your data by adding colored high, low, beginning, or end data points to the sparklines on your chart to help it stand out.

Click to watch Microsoft’s support office video on how to use sparklines to show data trends:

Microsoft Sparklines Video.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s