Data Storytelling and visualization: Google charts using google docs

Data from a Spreadsheet


========================================
   <div dir="ltr" style="text-align: left;" trbidi="on">
<br /></div>
<head>
<script type="text/javascript" src="https://www.google.com/jsapi"></script>
<script type="text/javascript">
google.load("visualization", '1', {packages:['corechart']});
google.setOnLoadCallback(drawChart);
function drawChart() {
  var query = new google.visualization.Query(
      'https://docs.google.com/spreadsheets/d/1ZKpGtoWg5yz_TX8CbadBVNJVaR_k4yIE81q0qpuEPLE/edit?usp=sharing');

  query.send(handleQueryResponse);
}

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

  var data = response.getDataTable();
  var options = {'title':'Crime among children 2011',
                       'width':400,
                       'height':600};
  var chart = new google.visualization.PieChart(document.getElementById('columnchart'));
  chart.draw(data, options);
}
</script>

<title>Data from a Spreadsheet</title>
</head>

<body>
<span id='columnchart'></span>
</body>
========================================

Data Storytelling and visualization

Sunday, 15 January 2017

Google charts using google docs

No comments:

Post a Comment