Reorder columns in a chart

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?

1 comment

  • 0
    Janice Janczyn

    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!


Please sign in to leave a comment.