x axis order

[Anonymous]

Hi there -- For some reason the order of my x axis has not followed the chronogical order of my data. When i inputted wk-11 q4 data into my file and refreshed the chart it pushed it 2nd in the chart.

Iv attached a screenshot of both the chart and my data below. Up to and including wk-7 q4 it followed the correct order.

Any help here to get wk-11 q4 to the end of the chart would be hugely appreciated.

Thanks,

Ryan.

[Anonymous]

This has worked @amitchandak 

Thank you so much 🙂

[Anonymous]

Thanks for reply @amitchandak 

So am i understanding you correctly that all i have to do is change the format in the file to that of what you outlined above ?

[amitchandak · Accepted solution]

@Anonymous , You need to create a column where

the week is like Wk-01-Q4

You need to create it in this manner 

"Wk" & format([WeekNumber], "00") &"-" & [Qtr Year]