I am working on a very basic "home budget" spreadsheet, to quickly see: A) how much money is left 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
I want to consolidate each of the categories into one slice of the pie that is 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 change formulas in a dozen other areas.