Using Sparklines

A sparkline is a very small line or bar chart, but, unlike typical charts which are designed to show as much information as possible and are separate to the data (in some cases even on a different sheet) sparklines fit into a single cell allowing them to appear immediately alongside the data for greater impact.



  • Click on the Insert tab on the ribbon and choose one of the sparkline styles.
  • Highlight the cells containing the data for the sparkline and specify where you would like sparkline to appear.
  • Click OK


Once the sparkline is in place, you will have an additional tab on the ribbon called Sparkline Tools, with all the formatting options available.



Are there any other Excel tips and tricks that you'd like to see next?  Let me know by leaving a comment and don't forget to share this post with others by using the buttons below.
Labels:

2 comments:

  1. Anonymous17 April 2014 at 10:53

    Thanks you make it so simple to understand

    ReplyDelete
    Replies
    1. Jen aka MissusMck19 April 2014 at 18:44

      Great to hear that it has helped. Hopefully future tips and tricks will be equally simple to understand :)

      Delete

Subscribe to: Post Comments (Atom)