Recently, I've played with a few Google API's and came across some cool ways of using Google Spreadsheets combined with the the Google Visualization Charts and Tables generator.
In this example I will show you a few ways to use the spreadsheet parameters to make a customized output of your data. Basically we are going to generate a chart or table using the Google Visualization API and the spreadsheet data as the source.
This example uses the following spreadsheet:
https://spreadsheets.google.com/pub?key=0AjcAYmrFtlKmdFk0M1cxdWdmQUs2aG13djhVZm9KQ1E#gid=19