Excel XP - How to assign Categories, Sub-Totals and Pie Charts
 

I am working on a budget and I have used Quicken in the past. Right now, I
set up a budget to track revenue and expenses for different categories and
different weeks. The spreadsheet is setup by month on each spreadsheet. I
would like to track my weekly, monthly and years expenses and revenues, by
categories. Also, I would like to be able to convert this to a chart or a
report, to see the breakdown of money, by category.

What would be the easiest way to do this? The category would need sub
categories too. The categories would be on the side, the weeks would be on
top going across. Please help.