Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a requirement whereby I need to sort a Line Chart by Months - with the first month being April (April to Mar)
Is there a way I can do this?
Many Thanks
If it is months then short it like TEXT
And if you are having a big data then just write up an expression .
Could you provide me with an example please?
Will I use the TEXT function in the Expression option in the Sort tab?
Many thanks for your help
Its ok i am to just exploring......
Brian.
In script editor there is order of month declaration as
SET MonthName=Jan,Feb........
Change it accordingly......as you need
Then sort it accordingly.