Using Sparklines to Show Data Trends

Whilst this is not a PivotTable tool, it is a great tool to use with PivotTables.

New in MS Excel 2010, a sparkline is a tiny chart in a worksheet cell that provides a visual representation of data. Use sparklines to show trends in a series of values, such as seasonal increases or decreases, economic cycles, or to highlight maximum and minimum values. Position a sparkline near its data for greatest impact. 

Applies To: MS Excel 2010 

  1. This tip will be based on the screen shot below

2.  Select Cell O5

3.  Select the Insert Tab, and then select Line under the sparklines group

4.  Select as below

5.  Select OK

6.  Use the auto fill handle in O5 to copy the chart to cell O8

7.  With the data range O5:O8 still highlighted select as below

The result will be as below





If you have any suggestions for an Excel Tips & Tricks topic, or you would like help with a particular function, please email [email protected] and yours could be the next Tip of the Week.

Alchemex provides examples of MS Excel procedures for illustration only, without warranty expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The MS Excel procedures on this web site are provided “as is” cannot be guaranteed that they can be used in all situations