This page was written as a repsonse to a query on the Google Visualizations forum - https://groups.google.com/forum/#!topic/google-visualization-api/eQxpx1_3WIQ

The data from the original Google Sheet had to be transposed, this can either be done in the sheet or using the code provided by Bhuman Soni - http://captaindanko.blogspot.com/2013/05/transpose-of-google-visualization-data.html and https://bitbucket.org/cptdanko/blog-code/src/0666cdce533db48cd89a4e2f02ef7e87a891c857/transpose.html?at=default.

There's more on this at https://stackoverflow.com/questions/16949993/inverting-rows-and-columns-on-google-area-chart

Orders by Department

The number of orders by department