Monday 27 January 2014


Thursday 23 January 2014

Sheet 2 Chart - Sheet, Range, Cols

<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/spreadsheet/ccc?key=0Autj6tQDIzyCdFRXYjdZMm1BMWFCd0hoZ3R2NTh2RWc#gid=0=Demo1&range=B3:C15&headers=1');
      query.setQuery('select B,C'); 
  query.send(handleQueryResponse01);
}

function handleQueryResponse01(response) {
  if (response.isError()) {
    alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage());
    return;
  }
  
  var options = {
          title: 'No of Beds Vs. Full Time Employees in Hospitals',
          vAxis: {title: 'No of Beds',  titleTextStyle: {color: 'red'}},
          width: 600,
          height : 800
        };


  var data = response.getDataTable();
  var chart = new google.visualization.BarChart(document.getElementById('ChartSpan4'));
  chart.draw(data, options );
}



</script>

<title>Sheet 2 Chart - Sheet, Range, Cols</title>
</head>

<body>

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

Wednesday 15 January 2014

and here i can put some text