Google Charts (Stacked Bar Chart)

Hi all,

I have been using google charts to create all type of charts but I have not been able to create a stacked combo bar.  I'm trying to create a chart that looks like...

Here's what I've done so far....

Here's the code for it...

function drawVisualization() {
  // Create and populate the data table.
  var data = google.visualization.arrayToDataTable([
    ['Fiscal Year', 'Planned', 'Actual', 'Anticipated'],
    ['FY12',  42,      938, 60],
    ['FY13',  135,      1120, 955]   
  ]);

  // Create and draw the visualization.
  var ac = new google.visualization.ComboChart(document.getElementById('visualization'));
  ac.draw(data, {
    title : 'SITES',
    width: 600,
    height: 400,
    vAxis: {title: "Number of Sites"},
    hAxis: {title: ""},
    seriesType: "bars",
    series: {5: {type: "line"},
    isStacked:true}
  });
}
¿

Select all Open in new window

Paste it in below and click row
https://code.google.com/apis/ajax/playground/?type=visualization#combo_chart