How do I summarize spending for charting??

S

Stumped

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum spending and group for each month/category 0
Complicated (I think) formula (Excel 2002) 2
How do I copy sub total data only onto a new worksheet? 2
How to set up a daily spending sheet? 3
make a spending tracker sheet 0
rearrange data for charting 1
How do I get rid of blank rows between data and Ctrl End result? 2
Pivot table: How do I make a monthly breakdown of daily data? 6

Top