I have a set of data which is similar to the following:Groceries     5.00Groceries    14.75Groceries     6.37Dinner Out   43.50Dinner Out   15.00I'd like to be able to use this data to create some graphs, such that (in this case) I'd have two categories, and the graph displays the sum, namely Groceries -> 26.12, Dinner Out -> 58.50. etc etc.Is this possible to do automatically, without me collapsing these rows into one sum per category?
Graphs with Google Spreadsheets - collapse data into one 'category'
google spreadsheets
In Excel you would use a Pivot Table and in Google Spreadsheets you would need to use a Gadget. I tried it with the Table by Google gadget and it was straightforward though, I've used pivot tables before so it was very familiar. Here is a more complicated example using a gadget I couldn't find.