Monday, 27 January 2014
Thursday, 23 January 2014
<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>
Subscribe to:
Posts (Atom)