Forum Discussion
Pivot Chart not sorting by date
The problem is that the field (column) you used in the Rows area uses the TEXT function, so it is a text value that is sorted in alphabetic order.
Use the Date field instead, and group it by Years and Months.
See the attached version
(I also cleared the check box to reverse the order of the x-axis)
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?
