I am working on a very basic "home budget" spreadsheet, the goal of which is to quickly be able to see: A) how much money is left over after the bills are paid and B) what % of withdrawals are going to what categories of expenses.
I have a Pie Chart built off of the following data (which is formatted as a table):
category withdrawal ------------------------- Utilities 108.59 Auto 119.13 Loans 500.00 Credit Card 78.00 Credit Card 161.00 Credit Card 16.00 Utilities 220.51
What I am attempting to do is consolidate each of the categories into one slice of the pie that is then displayed with it's Category as the label and the percentage of the pie it takes up. What I end up with is each category, regardless of it's uniqueness, taking a slice, like so:
Am I going to have to solve this with lots of hidden cells containing functions to add specific categories together? I was hoping I could arbitrarily add categories, simply within my table of data without having to go and change formulas in a dozen other areas.