Here's my spreadsheet : https://docs.google.com/spreadsheets/d/1CktfyseItSCYQa9isaFSiESBKhwgUn-mY4NZ7OIiN2A/edit?usp=sharing
What I want is to display a Pie Chart for '[email protected]' of the three (AEA, AA, UA) values from the row. This is how far I've got : google.setOnLoadCallback(drawVisualization); function drawVisualization() { var attendance = new google.visualization.ChartWrapper({ 'chartType':'PieChart', 'dataSourceUrl':'http://spreadsheets.google.com/tq?key=1CktfyseItSCYQa9isaFSiESBKhwgUn-mY4NZ7OIiN2A&pub=1', 'containerId':'chart_div', 'query':'SELECT C,D,E,F WHERE C = "[email protected]" ', }); attendance.draw(); } The code above outputs the correct row but only the first column (AEA) here Link to Chart output <http://bit.ly/1tIGzgL>. Any idea how I get values of D2, E2, F2 and display them as a Pie Chart? Cheers! -- You received this message because you are subscribed to the Google Groups "Google Chart API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-chart-api. For more options, visit https://groups.google.com/d/optout.
