Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

x axis order

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....
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    3 years ago

    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]

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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 ?