Objective: Graphically compare expenses for the same month in the previous year.
I believe this is called a year over year comparison.
I did do this with a pivot sheet, then a side by side column chart.
I started by adding a Year column and an “MM” for Month columns.
I haven’t set up an array formula to autofill year and the MM column is the numerical value of the month. I put that in because I don’t know how to sort months in order. There’s also a couple other things I think are needed to do like ignore categories flagged “Hide”, etc…