Difference between revisions of "Web Element: Google Chart"

@@ Line 3: / Line 3: @@
      <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
      <script type="text/javascript">
-    function drawSheetName() {
+function drawChart() {
-      var queryString = encodeURIComponent('SELECT B, C');
+  var query = new google.visualization.Query(URL);
+  query.send(handleQueryResponse);
+}
-      var query = new google.visualization.Query(
+function handleQueryResponse(response) {
-          'https://docs.google.com/spreadsheets/d/1YUqF27YsO2tVdFL1R6Oxu5BT5itjA_ozZDrekzfFclk/gviz/tq?sheet=Sheet1&headers=1&tq=' + queryString);
+  var data = response.getDataTable();
-      query.send(handleSampleDataQueryResponse);
+  var chart = new google.visualization.ColumnChart(document.getElementById('columnchart'));
-    }
+  chart.draw(data, null);
+}
-    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_3'));
-      chart.draw(data, { height: 400 });
-    }
      </script>
 </head>

Revision as of 13:12, 28 April 2020