Hi,

I have a pivot table and pivot chart to visualize some data. I made a slicer with months in it listing Jan, Feb.... etc

The problem I have is that I can't get the slicer buttons in the right order of advancing months. I think it is because Excel does not recognize my list as months but I have not found a way to fix it. I tried to format the source cells for the months as a date but it did not work. I also tried making a custom list which also did not work.

Any help would be appreciated

Ps, I can't really upload the excel file since is has a lot of data and uses macros, so its a big file