I've had better luck using the query code from https://developers.google.com/chart/interactive/docs/spreadsheets and the encodeURIComponent function.
For example: function drawChart() { var queryString = encodeURIComponent('SELECT C,A,E where E="Fun" ORDER BY C,A'); var query = new google.visualization.Query('google_sheet_url/gviz/tq?gid=1011451446&headers=1&tq=' + queryString); query.send(handleQueryResponse); } which comes from a live page <https://brisray.com/google-charts/csv.htm>. On Wednesday, April 10, 2024 at 2:53:46 PM UTC-4 Laurie Bennett wrote: > I'm using Google Charts to create pie charts on my web site. These charts > display if I hard-code the data, but I'm trying to use a query of a public > Google Sheet. It's not working, and the problem appears to be in this > section. > > // Callback to draw the chart > function drawChart() { > var query = new google.visualization.Query("[Google Sheet > URL]/gviz/tq?tq=[ENCODED QUERY]"); > query.send(handleQueryResponse); > } > > Bracketed info is replaced by the real values. The query has been encoded > using the tool on this page: > https://developers.google.com/chart/interactive/docs/querylanguage. > > I use double quotes around the URL because the query contains a where > clause with single quotes. > > -- 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 google-visualization-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/7447327e-2f33-4147-bf19-6055309fe144n%40googlegroups.com.