I have a set of data which is similar to the following:
Groceries 5.00 Groceries 14.75 Groceries 6.37 Dinner Out 43.50 Dinner Out 15.00
I'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?
I'm not even sure how I'd do this in Excel.