Sorting Chart of new data

[Anonymous]

Dear Friends,

I have added a new data Y21M10 to my chart, and after data/chart refresh, the value is reflected in the left before the value for Month7, 8 and 9.

I tried another way of sorting (sort descending) and it will be shown as M9,8,7 then 10.

Appreciate advice on how i can sort it in order of M7,8,9 then the latest data M10.

Thank you very much for your time and advice.

[amitchandak]

@Anonymous , As your numbers, is not 01, 02 it means in text sort 

You need to create a sort column Y21M01 

If you have the date you can create like 

Format([Date], "\YYY\MMM")

Mark this as sort column for you column 

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c

[Anonymous · Accepted solution]

Hi amitchandak,

Thanks for your advice, i will take reference from the video link you have provided and work on the date creation.

Best Regards.