When I tried to use Google Spreadsheet's form feature, I can't have a chart exactly present the collected data in the way I want. Here is an example:
(You can read results here)
I want a chart (or datatable) tells me how many votes Cat earns, so to others. If you don't have user-defined answer, then this can be solved by creating another sheet with COUNTIF function. That also is near unaccepted solution since that is totally manual handling and only suitable to having few answers.
I checked the Visualization API, and that do work. The trick is to use Google SQL-like Query Language:
select A, count(B) group by A order by count(B) descfor a set of grouped data. Then we can use any appropriate Visualization APIs to render the data in specific way.
General Installation
- Grab the XML URI and import it (Insert Plugin.../Custom...) in Spreadsheet.
- Select proper data range
- Set the options
- Apply
- Publish to get JavaScript code for your webpages or add to iGoogle
Want Other Types or Small Changes?
I list my current gadgets in Gallery section, if they just happen to fit you need, then simply grab them. If not, you are welcome to discuss with me. I will try to help, please also provide:
- Sample spreadsheet (with test data, of course).
- If you can draw a final result by hand, please do. That would be easy for me to understand what do you want.
- Currently, these gadget is only for being imported in Spreadsheet, not (directly) in iGoogle page.
- I will try to generalize you needs to have more people to use.
- Take a screenshot
- Allow me to read you spreadsheet (my Google account: livibetter@you_know_that)
- What would you be expecting?
- Leave me your email, gtalk, msn, or skype if you want.
Pie chart using Grouped data
Gadget XML: Revision 6 (Highlighted Source)
Features:
- Customization of Chart Title.
- Flexible to choice columns of grouped and aggregated.
- Choices of aggregation function: Max, Min, Count, Average, and Sum.
- Limit Results: Unlimited, 3, 5, 10, ...
- Choices of legend type and position.
Gadget Options:
From the options above, the data range is A1:B100. Group By Column B, which is What Do You Love Most. Apply aggregation function Count on Column A, which is Timestamp. Here Timestamp acts like a dummy column, whose values are not important, but in ordert to count how many rows in a group, we need a column.
The live result:
Datatable using Grouped Data
This gadget is similar to Pie chart, but a format of table.
Gadget XML: Revision 7 (Highlighted Source)
Features:
- Flexible to choice columns of grouped and aggregated.
- Customization of column labels of grouped and aggregated result.
- Choices of aggregation function: Max, Min, Count, Average, and Sum.
- Limit Results: Unlimited, 3, 5, 10, ...
Gadget Options:
The live result: