I Have Problem in Google chart.
I am using asp.net Mvc. After I fetch data from controller, I pass it into Google chart .
When i use manual data, for example:
['Month', 'Bolivia', 'Ecuador', 'Madagascar', 'Papua New Guinea', 'Rwanda', 'Average'], ['2004/05', 165, 938, 522, 998, 450, 614.6],
It Show me correctly .
But how can i add my data dynamically into Google chart ?
This is my code:
for (var i = 0; i < chartsdata.length; i++) { var data = google.visualization.arrayToDataTable([ ['Element', 'Density', {role: 'style'}], [chartsdata[i].MonthValue, chartsdata[i].CountValue, '#b87333'] ]); var options = { title: '' }; var chart = new google.visualization.ComboChart(document.getElementById('chartdiv')); chart.draw(data, options); }
Advertisement
Answer
The way you are doing is wrong.You should do something like below:
var data=[]; var Header= ['Element', 'Density', { role: 'style' }]; data.push(Header); for (var i = 0; i < chartsdata.length; i++) { var temp=[]; temp.push(chartsdata[i].MonthValue); temp.push(chartsdata[i].CountValue); data.push(temp); } var chartdata = new google.visualization.arrayToDataTable(data);