Month order

[#1]

hi

i am trying to show monthly statistics but i can't get the moths in order the chart is displayed like the image which i have shown below..

how can i get the correct order??

ex; Jan , Feb ,Mar, Apr, May... etc

thank you in advance

[ashfaq_haseeb]

Hi,

Go to sort tab and play around with sorting there,

or post a sample app.

Regards

ASHFAQ

[#3]

i did try every thing in the sorting tab but nothing worked

[ashfaq_haseeb]

Hi,

Sample app please

Regards

ASHFAQ

[#5]

i am using a personal edition so i dnt think u will be able to open it even if i post the sample app 😕

[ashfaq_haseeb]

Hi,

I can open any application as I have Licence.

But you cannot open any other application.

By seeing your application I can guide you.

Regards

ASHFAQ

[robert_mika]

Check your data source

Maybe your April Year is different than the others(let say 2015 to 2014 for Jan-May)

[#8]

i attached my Excel as well

[ashfaq_haseeb]

Hi,

Your document is corrupted.

Can you upload it again.

Regards

ASHFAQ

[ashfaq_haseeb · Accepted solution]

May be like this

go to sort tab select sort by expression --> ascending order

Below is the expression. Make sure to select ascending order.

=match(YourMonthField, 'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep', 'Oct', 'Nov', 'Dec')

Regards

ASHFAQ