Hey guys, I would like to pull data from a Google Sheet document and use
different tabs for different charts. A column chart that pulls data from
tab number 1 and a gauge that pulls data from tab 2. This one seems even
trickier because I need to build a separate gauge for each of the reps and
just use the maximum files column and the current files column.
Anywho, here is what I have so far (not much) ...
<script type="text/javascript">
google.load('visualization', '1', {'packages':['corechart']});
// Set a callback to run when the Google Visualization library is loaded.
google.setOnLoadCallback(drawChart);
// Once everything is loaded; draw the chart here...
function drawChart() {
var query = new google.visualization.Query(
'https://docs.google.com/spreadsheet/ccc?key=1LAHAW29fAeDc_vrQ9hpBKL0AO6nVB3XD_WMoFOXlBxA&usp=drive_web#gid=0');
query.send(handleQueryResponse);
}
function handleQueryResponse(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('closing-product-bar-chart'));
chart.draw(data, {
legend: { position: 'right' },
title: 'Closing Counts By Product',
});
var chart = new
google.visualization.Gauge(document.getElementById('short-sale-by-rep-gauge'));
chart.draw(data, {
legend: { position: 'none' },
title: 'Open File Capacity',
});
}
</script>
And in the body I currently have:
<div id="closing-product-bar-chart" style="width:100%; height:
350px;"></div>
<div id="short-sale-by-rep-gauge" style="width:100%; height: 350px;"></div>
So I am confused as how to call one master Google Sheet and then have each
chart use a certain tab, or certain cells within that Sheet.
Thanks!
--
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 http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/d/optout.
