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
Go to sort tab and play around with sorting there,
or post a sample app.
i did try every thing in the sorting tab but nothing worked
Sample app please
i am using a personal edition so i dnt think u will be able to open it even if i post the sample app :/
I can open any application as I have Licence.
But you cannot open any other application.
By seeing your application I can guide you.
Check your data source
Maybe your April Year is different than the others(let say 2015 to 2014 for Jan-May)
i attached my Excel as well
Your document is corrupted.
Can you upload it again.
i have attached the Excel sheet also
Hi use this expression
=match(Month, 'Jan','Feb','Mar','Apr','May','Jun','Jul','Aug','Sep', 'Oct', 'Nov', 'Dec') for sorting.
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')
It worked thank you soooo much... really appreciate your help
Retrieving data ...