Tracking my expenses and graphing it.

A:A is a drop-down menu with a series of possible expense categories ie gas,
food, utilities, misc expenses. C:C is the dollar amount of this expense.

obviously these aren't going to be in any order since I am adding to the
list on a daily basis. What I want to do is graph my expenses by category,
though when I try to graph it, it plots for every entry of Misc Expense etc.
What I would like it to do is subtotal every item from a particular category
then graph the sub totals.
I was trying to do this with a variable... in programming it would look
something like this: variable=variable+dollar_amount or x=x+y
in excel.... variable=variable+C3
or =IF(A3="misc expense", misc=misc+C3, if(A4="Gas",gas=gas+C3.......

Any help on this would be terrific! Thanks!

Try Pivot tables and pivot chart reports from the data menu.
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Jez" wrote:

Tracking my expenses and graphing it.

A:A is a drop-down menu with a series of possible expense categories ie gas,
food, utilities, misc expenses. C:C is the dollar amount of this expense.

obviously these aren't going to be in any order since I am adding to the
list on a daily basis. What I want to do is graph my expenses by category,
though when I try to graph it, it plots for every entry of Misc Expense etc.
What I would like it to do is subtotal every item from a particular category
then graph the sub totals.
I was trying to do this with a variable... in programming it would look
something like this: variable=variable+dollar_amount or x=x+y
in excel.... variable=variable+C3
or =IF(A3="misc expense", misc=misc+C3, if(A4="Gas",gas=gas+C3.......

Any help on this would be terrific! Thanks!