Stacked graph: spending categories

[a.newbury]

Curious if anyone has any ideas on creating a stacked graph of spending by category across time? Like the Monthly Analysis sheet but broken up into spending categories by color. Seems like the best way to get both the spending by category analysis of a pie chart but also the trends over time for both total spending and individual categories.

Thanks!

ng)

[Clint.C]

@a.newbury you should be able to create this graph by first creating a pivot table against the transaction table and then inserting a stacked area chart off of the pivot table.