task Dynamic Google Charts using Google Spreadsheet as Data Source

For a new client, the Calvert Foundation, I'm building some Google Visualization Charts. The charts, which will present data from the Foundation quarterly reports, will directly source data that is stored in a Google spreadsheet. This will allow Foundation staff to quickly and easily update the chart data each quarter simply by updating the spreadsheet. As additional task, I'll soon build a Geocode chart (map) using the same technique.