Hiya, I am trying to get data out of a Google spreadsheet to make some charts. I have it working well for line charts but need to get a pie chart of column sums.
You can see it here... http://www.netmechanics.co.nz/eg/grapher/index2.htm My query is for example - select sum(B), sum(C) where date '2008-1-1' <= A and date '2010-1-1' >= A I think I need to pivot it to get a column of labels and a column of totals ... does anybody know how I would do this? The spreadsheet is here... https://spreadsheets.google.com/spreadsheet/pub?key=0ArQoG4oepsJldFhYVGQ3SGVjYS15YXpFbDRBRlNYZ2c&output=html Many thanks... -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
