Monday, February 13, 2012

New Feature: Sparklines

Ever wanted to quickly see a trend in your data?  Want to add a quick small graph to a UI? Now you can with Sparklines!  Sparklines are a quick and dirty way to see a trend in your data IN a cell.  We can create quick line graphs and bar graphs using Sparklines.

See my example below that looks at average monthly temperatures for various cities in Nebraska, USA.

Note that you can change the background color and line color using the font/background color buttons from the editing toolbar.  I also created a little tool that quickly generates the sparkline for a given city using the drop down.  Enjoy and post any questions in the comments section!

To play around with this feel free to access this spreadsheet using the link below.  Make sure you go to File>Make a copy in order to see formulas and use the drop down feature of the city chooser tool.

Sparklines Example Spreadsheet

Also, you will see below that the embedded Spreadsheet does not show Sparklines due to a current issue with Publishing and Exporting.  Please see this post for updated information about the issue.  To see the Sparklines click on the link above.  Below the embedded Spreadsheet is a screenshot of what it looks like.

Cheers!



Screenshot:

No comments:

Post a Comment