How do I summarize spending for charting??
 

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

How do I summarize spending for charting??
 

Look at pivot tables:

http://peltiertech.com/Excel/Pivots/pivotlinks.htm

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Stumped" wrote in message
...
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