blogger - プログラム倉庫

<script type="text/javascript" src="https://www.google.com/jsapi"></script>
    <script type="text/javascript">
      google.load("visualization", "1", {packages:["corechart"]});
      google.setOnLoadCallback(lotus);
var x=new Array(); 
var y=new Array(); 
var z=new Array(); 
var k=new Array(); 
 
function lotus() {
 
var query = new google.visualization.Query(
      'https://docs.google.com/spreadsheet/ccc?key=0Atc7WttLh-m7dFoySGhoeWhBVzNXVHNQdXNwcF9xRkE&usp=sharing');
query.send(handleQueryResponse);
}
 
function handleQueryResponse(response) {
  if (response.isError()) {
    alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage());
    return;
  }
 
number=348;
 
for(s=1;s<number+1;s++){
x[s]=response.getDataTable().getValue(s-1,0)+"年";
x[s]=x[s]+response.getDataTable().getValue(s-1,1)+"月";
y[s]=response.getDataTable().getValue(s-1,2);
z[s]=response.getDataTable().getValue(s-1,3);
}
 
for(s=1;s<number+1;s++){
if(x[s]==null)x[s]="";
if(y[s]==null)y[s]=0;
}
 
var str;
 
var data = new google.visualization.DataTable();
data.addColumn('string', "期間");
data.addColumn('number', "一致指数");
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]);
data.setCell(s-1, 2, z[s]);
}
 
var options = {title: "内閣府(景気動向指数)"};
 
var chart = new google.visualization.LineChart(document.getElementById('lotus'));
chart.draw(data, options);
 
}
 
  </script>
    <div id="lotus" style="width: 700px; height: 500px;"></div>