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

How do I copy sub total data only onto a new worksheet? 2
Complicated (I think) formula (Excel 2002) 1
How to set up a daily spending sheet? 3
How do I get rid of blank rows between data and Ctrl End result? 2
How do I summarize a selection? 1
Summing totals on separate worksheet based on 2 criteria 4
Chart to show totals by monthly when source data is by day 1
Pivot table: How do I make a monthly breakdown of daily data? 6

Top