First, do you mean a Google Sheet or Excel? Google Sheets are much easier to work with and the charts will update as soon as the sheet is, and the web page refreshed.
Excel is going to need a bit more help to work properly and there's very little help around for doing it. There's some at the following, but I haven't used them... Tushar Mehta at http://www.tushar-mehta.com/publish_train/xl_vba_cases/excel_google_chart_api/ used VBA in Excel to do it. yuriarfil on GitHub also uses VBA - https://github.com/yuriarfil/google-visualization-vba SheetJS on GitHub uses JavaScript to create the JSON data As far as I know there's just one example of using a Google Sheet in the Google Visualizations help and that's at https://developers.google.com/chart/interactive/docs/spreadsheets#creating-a-chart-from-a-separate-spreadsheet You may also need to look at the Query Language help at https://developers.google.com/chart/interactive/docs/querylanguage If you're updating the spreadsheet you may be better off just specifying the columns from it you want to import. For example, my table at http://hmsgambia.org/crewlist.htm is drawn from the sheet at <https://docs.google.com/spreadsheets/u/1/d/1kjOTQMAlWc-j6G_XfFUJIzAxuvmyxygQh0q1Dpn4oRU/edit?usp=drive_web&ouid=112178024000151193292> https://docs.google.com/spreadsheets/d/1kjOTQMAlWc-j6G_XfFUJIzAxuvmyxygQh0q1Dpn4oRU/edit#gid=0 and uses: function drawChart() { var queryString = encodeURIComponent('SELECT A, B, C, D, E order by A'); var query = new google.visualization.Query( 'https://docs.google.com/spreadsheets/d/1kjOTQMAlWc-j6G_XfFUJIzAxuvmyxygQh0q1Dpn4oRU/gviz/tq?gid=0&headers=1&tq=' + queryString); query.send(handleQueryResponse); } function handleQueryResponse(response) { if (response.isError()) { alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage()); return; } var crewDataTable = response.getDataTable(); ... ... } or you can omit the querystring altogether and simply use var query = new google.visualization.Query( 'https://docs.google.com/spreadsheets/d/1kjOTQMAlWc-j6G_XfFUJIzAxuvmyxygQh0q1Dpn4oRU/gviz/tq?gid=0&headers=1'); in which case Google will try and import the entire sheet to work on. Unless you are using the authorization method at https://developers.google.com/chart/interactive/docs/spreadsheets#authorization the only thing to remember is to make the Google Sheet public or "viewable to anyone with the link". I don't use authorization because I don't keep anything in the Sheets that is not going to be put onto a web page in one form or another anyway. Other than where the data comes from to create the datatable there's no difference in the code to be used to create your charts, and all the methods and events for your particular chart types will work as they should. I hope this helps. -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/b3829fc4-9d24-41a7-94cb-ccb1ba0acd53%40googlegroups.com.
