3 Specifying Range of Data and Selecting Columns : Google Charts with Google Docs data
<head> <script type="text/javascript" src="https://www.google.com/jsapi"></script> <script type="text/javascript"> google.load("visualization", '1', {packages:['corechart']}); google.setOnLoadCallback(drawChart01); function drawChart01() { var query = new google.visualization.Query( 'https://docs.google.com/a/yantrajaal.com/spreadsheet/ccc?key=0AqawrNPy9RHodDNvMXdPX1NqanlyLVdtbEE1dlJ3LUE&sheet=Demo3&range=C3:I12&headers=1'); query.setQuery('select C,D,1000*G,H'); query.send(handleQueryResponse01); } function handleQueryResponse01(response) { if (response.isError()) { alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage()); return; } var options = { title: 'Industrial Production Index', vAxis: {title: 'Sector', titleTextStyle: {color: 'red'}}...
Comments
Post a Comment