Microsoft Excel Data Table

So I have alot going on with my current table, I use it for showing my portfolio in a snap. Portfolio in a snap Except it's lacking a pretty looking pie chart. Here's the thing, I can do what others have suggested. Just put a hidden category tally with a sum of each blah blah blah, except when I change my portfolio that wouldn't even matter. This thing is changing constantly.

So how can I get excel to be smart, add up my market value's in a specific category and get those into a pie chart. How my chart is currently. Ugly Pie As you can see that thing is just ugly with many of the same labels. Help me excel gods please, I am begging you! Thank You!

Recent Questions...