Hello,
I am having a charting category issue.
I am building a monthly budget spreadsheet using Excel '07. I inserted a 3D pie chart highlighting C2:C37 (categories) and D2:D37 (withdrawal amounts) to visually illustrate how much I am spending on bills, gas, food, fast food, etc. However, I cannot get Excel to recognize multiple instances of "household/food" as a single entity and lump the corresponding totals into a single category, so I get a myriad of slivers representing individual purchases, as opposed to the broad categories I desire. Any suggestions?
I am grateful for any help you may be able to offer.
Attached is a screenshot of the chart in its present, useless form. (Pertinent private information has been blurred out.)
Thank you!
Flavor Dave
Bookmarks