how can I order the days of week ? I've a graph and I would display the names of the days in order as they are in the week:
Mon Tue Wed Thu Fri Sat Sun
I retrieved the names by the weekday function, but they aren't in the right sequence.
Is it possible ?
Thanks in advance for your help
Weekday() should have created dual values with a numeric representation which you could use to sort your values.
In your chart, select numeric as sort order in sort tab.
The second option works great for me. I just needed to capitalize them to match my existing day characters. Thanks much!
Retrieving data ...