week days order

[Anonymous]

Dear all,

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

[swuehl · Accepted solution]

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.

[MayilVahanan]

HI

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

or

Sort ->expression

=Match(WeekDay,'Mon','Tue','Wed','Thu','Fri','Sat','Sun')

[Anonymous]

Thanks!!!

[#5]

The second option works great for me. I just needed to capitalize them to match my existing day characters. Thanks much!