Google Visualization API & Google Apps Script & Google Sheet (2)

<script type="text/javascript" src="https://www.google.com/jsapi"></script> 
<script type="text/javascript"> 
google.load("visualization", "1", {packages:["corechart"]});

google.setOnLoadCallback(getSpreadsheetData);

function getSpreadsheetData() {
         google.script.run.withSuccessHandler(getPicData).getData();
}

function getPicData(data) {
         //create data table object
         var dataTable = new google.visualization.DataTable();

         //define columns
         dataTable.addColumn('string', data[0][0]);  //日期
         dataTable.addColumn('number', data[0][4]);  //收盤價
         dataTable.addColumn({type: 'string', role: 'annotation'});
         dataTable.addColumn('number', data[0][25]); //摩台換倉成本
         dataTable.addColumn({type: 'string', role: 'annotation'});
         //dataTable.addColumn({type: 'string', role: 'annotationText'});

         for (var i = 0; i < data.length; i++)
         {
              if(i != data.length-1)
                 dataTable.addRow([data[i][0], parseFloat(data[i][4]), null, parseFloat(data[i][25]), null]);
              else if(i == data.length-1)
                 dataTable.addRow([data[i][0], parseFloat(data[i][4]), String(parseFloat(data[i][4])), parseFloat(data[i][25]), String(parseFloat(data[i][25]))]);
          }               

          var options = {width: 1400, 
                         height: 800, 
                         is3D: true, 
                         title: '摩台未平倉量與成本'};

          var chart = new google.visualization.LineChart(document.getElementById('chart'));
          chart.draw(dataTable, options);  
} 
</script>