I've set up a map and chart visualization from a google spreadsheet (see at charcoalproject.org/resources/charcoal-index).
Currently the google spreadsheet link for the visualization defines a specific range of cells to include because I have columns/rows that I do not want shown in the map/chart. I add new rows to the spreadsheet occasionally and want that shown on the chart. Instead of going into the code and changing the the range of cells, is there anyway to do this dynamically?
Where I update:
var query = new google.visualization.Query('http://spreadsheets.google.com/ccc?key=0Ah5tC2tiRTuZdFRjaDBmaTlqTTBFZTViVFVmSHU4U3c&hl=en&range=A1:F17&headers=1');
If I just get rid of the range (&range=A1:F17), the whole chart shows up.
I could define the columns (something like geoView.setColumns([0, 1]); where the data set is called geoview) if I get rid of the excess rows in the spreadsheet. Not ideal, but the best option I can think of...
Is there a better way to do this?