I'm trying to build a chart from a google spreadsheet and embed it in
another google spreadsheet. As a starting point, I wanted to just test the
example given on this
page:
https://developers.google.com/chart/interactive/docs/spreadsheets#sheet-name
So I made a new spreadsheet, opened the script editor and pasted the
example code into it:
function drawSheetName() {
var queryString = encodeURIComponent('SELECT A, H, O, Q, R, U LIMIT 5
OFFSET 8');
var query = new google.visualization.Query(
'https://docs.google.com/spreadsheets/d/1XWJLkAwch5GXAt_7zOFDcg8Wm8Xv29_8PWuuW15qmAE/gviz/tq?sheet=Sheet1&headers=1&tq='
+ queryString);
query.send(handleSampleDataQueryResponse);
}
function handleSampleDataQueryResponse(response) {
if (response.isError()) {
alert('Error in query: ' + response.getMessage() + ' ' +
response.getDetailedMessage());
return;
}
var data = response.getDataTable();
var chart = new
google.visualization.ColumnChart(document.getElementById('chart_div'));
chart.draw(data, { height: 400 });
}
I then created a shape in my google sheet and assigned the script
"drawSheetName" to it. Upon clicking the shape, I get the
error: ReferenceError: "google" is not defined.
What am I doing wrong here?
--
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 post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/google-visualization-api.
To view this discussion on the web visit
https://groups.google.com/d/msgid/google-visualization-api/96c3190b-5d27-4152-9296-fb4c602eca60%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
