Hello everyone,
I'm thinking that the answer to this should be fairly easy, but it is eluding me right now. I have a personal expense tracker that I use to chart my families and my expenses over two week periods to make sure that we are staying within our means. Every two weeks gets its on spreadsheet which filters back to a central dashboard that has our total income/expenditures for those two weeks plus the other weeks since I've had this and gives running totals of what we have in our various checking and savings accounts plus what our current credit card balances are.
When we log expenses, we log three pieces of information. The amount, the recipient of the funds, and what category it falls into. I validated the cells so that they can only be one of these choices:
[TABLE="width: 117"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Car - Gas[/TD]
[/TR]
[TR]
[TD]Car - Insurance[/TD]
[/TR]
[TR]
[TD]Car - Payment[/TD]
[/TR]
[TR]
[TD]Car - Upkeep[/TD]
[/TR]
[TR]
[TD]Cell Phone[/TD]
[/TR]
[TR]
[TD]Clothes[/TD]
[/TR]
[TR]
[TD]Entertainment[/TD]
[/TR]
[TR]
[TD]Food - Dining Out[/TD]
[/TR]
[TR]
[TD]Food - Groceries[/TD]
[/TR]
[TR]
[TD]Food - Milk[/TD]
[/TR]
[TR]
[TD]Giving - Charity[/TD]
[/TR]
[TR]
[TD]Giving - Presents[/TD]
[/TR]
[TR]
[TD]House - Mortgage[/TD]
[/TR]
[TR]
[TD]House - Upkeep[/TD]
[/TR]
[TR]
[TD]House - Utilities[/TD]
[/TR]
[TR]
[TD]Medical - Dentist[/TD]
[/TR]
[TR]
[TD]Medical - Vet[/TD]
[/TR]
[TR]
[TD]Miscellaneous[/TD]
[/TR]
[TR]
[TD]Savings[/TD]
[/TR]
</tbody>[/TABLE]
What I would like to do is have a stacked column chart for each of those two weeks that shows me the total amount we spent on house categories and within that breaks down that this part was on the mortgage, this part was an upkeep, and this part was on utilities. So, that would be one column in the chart, and the other columns would be the same thing except for the car category, the food category, etc.
Can anyone tell me how to set up my table to get that effect?
I'm thinking that the answer to this should be fairly easy, but it is eluding me right now. I have a personal expense tracker that I use to chart my families and my expenses over two week periods to make sure that we are staying within our means. Every two weeks gets its on spreadsheet which filters back to a central dashboard that has our total income/expenditures for those two weeks plus the other weeks since I've had this and gives running totals of what we have in our various checking and savings accounts plus what our current credit card balances are.
When we log expenses, we log three pieces of information. The amount, the recipient of the funds, and what category it falls into. I validated the cells so that they can only be one of these choices:
[TABLE="width: 117"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Car - Gas[/TD]
[/TR]
[TR]
[TD]Car - Insurance[/TD]
[/TR]
[TR]
[TD]Car - Payment[/TD]
[/TR]
[TR]
[TD]Car - Upkeep[/TD]
[/TR]
[TR]
[TD]Cell Phone[/TD]
[/TR]
[TR]
[TD]Clothes[/TD]
[/TR]
[TR]
[TD]Entertainment[/TD]
[/TR]
[TR]
[TD]Food - Dining Out[/TD]
[/TR]
[TR]
[TD]Food - Groceries[/TD]
[/TR]
[TR]
[TD]Food - Milk[/TD]
[/TR]
[TR]
[TD]Giving - Charity[/TD]
[/TR]
[TR]
[TD]Giving - Presents[/TD]
[/TR]
[TR]
[TD]House - Mortgage[/TD]
[/TR]
[TR]
[TD]House - Upkeep[/TD]
[/TR]
[TR]
[TD]House - Utilities[/TD]
[/TR]
[TR]
[TD]Medical - Dentist[/TD]
[/TR]
[TR]
[TD]Medical - Vet[/TD]
[/TR]
[TR]
[TD]Miscellaneous[/TD]
[/TR]
[TR]
[TD]Savings[/TD]
[/TR]
</tbody>[/TABLE]
What I would like to do is have a stacked column chart for each of those two weeks that shows me the total amount we spent on house categories and within that breaks down that this part was on the mortgage, this part was an upkeep, and this part was on utilities. So, that would be one column in the chart, and the other columns would be the same thing except for the car category, the food category, etc.
Can anyone tell me how to set up my table to get that effect?
