I have downloaded my last six months spending from my banks website and
created a spreadsheet which I have reduced to 3 relevant columns - Date
(mm/yy), Category (utilities, food, etc) and Amount.

I want to be able to summarize and chart the data by the total Amount spent
on each Category, by month.

I have tried sorting and subtotaling but can't seem to extract the subtotals
so that I can chart the data without using the = command to reference the
subtotaling cell.

Anyway to automate this step, or is there a better solution??

Tx