SatsuMX
New Member
- Joined
- May 15, 2017
- Messages
- 24
Hi,
I'm trying to show total expenses for each person, in a separate category, from a pivot table, as follows:
So each bar represents the total spent, while each color represents the category it was spent on. I'm having trouble getting Excel to do this, as it just creates a new bar for each category instead. I've already tried many things and I just can't seem to get it to work. Is this even possible in Excel?
Really appreciate any help.
I'm trying to show total expenses for each person, in a separate category, from a pivot table, as follows:

So each bar represents the total spent, while each color represents the category it was spent on. I'm having trouble getting Excel to do this, as it just creates a new bar for each category instead. I've already tried many things and I just can't seem to get it to work. Is this even possible in Excel?
Really appreciate any help.