Pivot Table/Chart Keeps Resorting

[jrod59]

Hi,

I have a "day of the week" pivot chart and every time I use the slicer from the pivot table, it resorts it to a random order. Therefore the x axis on my graph does not stay in the Sunday, Monday, Tuesday, etc. order.

I know there is a way to "lock" the order you manual pick in place. I have done it before, but I cant remember.

Thank you

[oeldere]

difficult to tell, without seeing the file, but what is the new order.

You want (result is) "Sunday, Monday, Tuesday, etc. order."