sort custom date format in google sheet pivot and chart

139 Views Asked by At

I set the format of the date in my google sheet so it display 'YY' and 'MMM' (eg: Jan-22, Feb-22). but when it pivoted, it's not in date order, but in alphabetical order (as of: Feb-22 before Jan-22).
is there a way I can sort the pivot and then the chart so it will be in date order?

pivot with unordered date

chart with unordered date

0

There are 0 best solutions below