<html>
<head>
<meta charset="utf-8"/>
<script src="https://www.google.com/jsapi"></script>
<script src="sample.js"></script>
<title>経済統計練習帳</title>
</head>
<body onload="sample()">
</a>
<div id="memo" style="width: 800px; height: 500px;">準備中</div>
<br>
</body>
</html>
google.load("visualization", "1", {packages:["corechart"]});
var x=new Array();
var y=new Array();
var z=new Array();
var k=new Array();
function sample() {
var query = new google.visualization.Query(
'https://docs.google.com/spreadsheets/d/1M6siKlf-q2HjLQO4ojhcxKoHPyLaPHtU6UXQ_Bynsow/edit?usp=sharing');
query.send(handleQueryResponse);
}
function handleQueryResponse(response) {
if (response.isError()) {
alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage());
return;
}
number=132;
for(s=1;s<number+1;s++){
x[s]=""+response.getDataTable().getValue(s-1,0);
y[s]=response.getDataTable().getValue(s-1,1);
}
var str;
var data = new google.visualization.DataTable();
data.addColumn('string', "年月");
data.addColumn('number', "第３次産業活動指数");
data.addRows(number);
for(s=1;s<number+1;s++){
data.setCell(s-1, 0, x[s]);
data.setCell(s-1, 1, y[s]);
}
var options = {title: "出所;経済産業省「第３次産業活動指数」"};
var chart = new google.visualization.LineChart(document.getElementById('memo'));
chart.draw(data, options);
}
最終更新：2014年05月01日 07:07
