G
Guest
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!
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!