Forum Discussion
Pivot Chart not sorting by date
HansVogelaar brilliant! Thank you so much for helping.
In the version you sent back though, all data from Sept-Nov is missing? Any ideas?
The Source Data of the pivot table was set to 'Edited data'!$A$1:$R$5797. It should have been 'Edited data'!$A$1:$R$6421. If you change this, the missing months will appear.
HansVogelaar thank you, but now the first change you made has reset and I can't duplicate what you did.
How have you created the 'Years' field to add to Rows and display date order rather than alphabetical?
I used the Date column instead of the Month/Year column in the Rows area of the pivot table.
I then right-clicked any of the dates in the pivot table and selected Group... from the context menu.
I selected only Months and Years in the dialog:
Confirm by clicking OK. this adds the Years field in the Rows area.
Since Date is a real date column instead of a text column, it is automatically sorted correctly.
See the attached version.
 
HansVogelaar you're my hero! Thanks again for your help. 🙂