Difference between revisions of "Web Element: Google Chart"


Line 4: Line 4:
 
     <script type="text/javascript">
 
     <script type="text/javascript">
 
function drawChart() {
 
function drawChart() {
   var query = new google.visualization.Query('https://docs.google.com/spreadsheets/d/1YUqF27YsO2tVdFL1R6Oxu5BT5itjA_ozZDrekzfFclk/gviz/tq?sheet=Sheet1&headers=1&range=B2:C20');
+
   var query = new google.visualization.Query('https://docs.google.com/spreadsheets/d/1YUqF27YsO2tVdFL1R6Oxu5BT5itjA_ozZDrekzfFclk/gviz/tq?headers=1&range=A1:C4');
 
   query.send(handleQueryResponse);
 
   query.send(handleQueryResponse);
 
}
 
}
Line 33: Line 33:
 
//          query: 'SELECT A,D WHERE D > 100 ORDER BY D',
 
//          query: 'SELECT A,D WHERE D > 100 ORDER BY D',
 
//          options: {'title': 'Countries'},
 
//          options: {'title': 'Countries'},
           dataSourceUrl: 'http://spreadsheets.google.com/tq?key=1YUqF27YsO2tVdFL1R6Oxu5BT5itjA_ozZDrekzfFclk&pub=1&range=B2:C20',
+
           dataSourceUrl: 'http://spreadsheets.google.com/tq?key=1YUqF27YsO2tVdFL1R6Oxu5BT5itjA_ozZDrekzfFclk&pub=1&range=A1:C4',
 
           containerId: 'vis_div'
 
           containerId: 'vis_div'
 
         });
 
         });

Revision as of 13:27, 28 April 2020