結合 - プログラム倉庫

google.load("visualization", "1", {packages:["corechart"]});
var x=new Array(); 
var y=new Array(); 
var z=new Array(); 
 
function lotus() {
 
var query = new google.visualization.Query(
      'https://docs.google.com/spreadsheet/ccc?key=0Atc7WttLh-m7dFJjOHRSZEtHMDZrUnNQQmExTS12ZEE&usp=sharing');
query.send(handleQueryResponse);
}
 
function handleQueryResponse(response) {
  if (response.isError()) {
    alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage());
    return;
  }
 
number=80;
 
for(s=1;s<number+1;s++){
x[s]=response.getDataTable().getValue(s-1,0);
y[s]=response.getDataTable().getValue(s-1,1);
z[s]=response.getDataTable().getValue(s-1,2);
}
 
for(s=1;s<number+1;s++){
if(x[s]==null)x[s]="";
if(y[s]==null)y[s]=0;
if(z[s]==null)z[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('memo'));
chart.draw(data, options);
 
}