Forum Discussion
Pivot Chart not sorting by date
Hi, I cannot get the horizontal axis in the chart picture to display in date order. I have tried around 10-15 differnt fixes suggested on similar threads, if someone could let me kno...
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.