i want display all the sector in the pie but it only displaying 2...plz help me
google.load('visualization', '1',{'packages': [ 'corechart']});
function drawColumnChart() {
var query = new google.visualization.Query(
'
https://docs.google.com/spreadsheet/ccc?key=0ArFGfpB6duBGdFpSa2s0TEliUlVBVWdDbEs2N0ttNnc#gid=0');
query.send(draw);
}
function draw(response) {
if (response.isError()) {
alert('Error in query');
}
var data = response.getDataTable();
var chart = new google.visualization.ColumnChart(document.getElementById('chart_div'));
chart.draw(data, {'isStacked': true, 'legend': 'bottom','vAxis': {'title': ''}});
}
function drawPieChart(){
var queryP = new google.visualization.Query(
'
https://docs.google.com/spreadsheet/ccc?key=0ArFGfpB6duBGdFpSa2s0TEliUlVBVWdDbEs2N0ttNnc#gid=0' );
queryP.send(handleQueryResponse);
}
function handleQueryResponse(response) {
if (response.isError()) {
alert('Error in query: ' + response.getMessage() + ' ' + response.getDetailedMessage());
return;
}
var dataP = response.getDataTable();
var chart1 = new google.visualization.PieChart(document.getElementById('pie_div'));
chart1.draw(dataP);
}
function drawVisualization(){
drawColumnChart();
drawPieChart();
}
google.setOnLoadCallback(drawVisualization);