<html>
<head>
<script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
<script type="text/javascript">
google.charts.load('current', {'packages': ['corechart']});
google.charts.setOnLoadCallback(initialize);
function initialize() {
var query = new google.visualization.Query(
'https://spreadsheets.google.com/pub?key=pCQbetd-CptF0r8qmCOlZGg');
query.send(draw);
}
function draw(r) {
if (r.isError()) {
alert('Error in query');
}
var tc = r.getDataTable();
n=tc.getNumberOfRows()
m=tc.getValue(0, 0);
alert(m);
var chart = new google.visualization.ColumnChart(
document.getElementById('d'));
chart.draw(tc, {'isStacked': true, 'legend': 'bottom',
'vAxis': {'title': 'tickets'}});
}
</script>
</head>
<body>
<div id="d" style="align: center; width: 700px; height: 300px;"></div>
</body>
</html>
最終更新:2017年07月11日 19:43