GeoChart Test StackOverflow

by multiformeingegno

HTML

<script src="https://www.gstatic.com/charts/loader.js"></script>
<div id="geochart-colors" style="width: 100%; height: 100%;"></div>

JavaScript

google.charts.load('current', {
      'packages': ['geochart', 'table']
    });
    google.charts.setOnLoadCallback(drawRegionsMap);

    function drawRegionsMap() {
      var query = new google.visualization.Query('https://docs.google.com/spreadsheets/d/1TFoK7OXrTmNDVekyWZbqyY-KMZ5QY_N-Kj8hrpmgH6M/edit?gid=1023061181&headers=1&range=A1:B');
      query.send(handleQueryResponseTR);
    }

    function handleQueryResponseTR(response) {
      if (response.isError()) {
        alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage());
        return;
      }

      var options = {
        displayMode: 'markers',
      };

      var data = response.getDataTable();

      var chart = new google.visualization.GeoChart(document.getElementById('geochart-colors'));

      chart.draw(data, options);
    };