I have created a bar chart, displaying data by each month, which has all the data displayed correctly but has put the months (x-axis) in alphabetical order rather than in chronological order.
I have tried everything I can see but can't change the order, has anyone else come across this?
Hi Peter,
Set your x-axis Format (under the Properties tab) to Date/Time. The Input Format must match the format returned by the formula and the Display Format can be whatever you choose. Then you can set Sort to Oldest to Newest.
I hope this helps!
Thanks,
Janice
