Display line chart labels are Mon-YYYY, but sorted correctly

[gundley]

Hi, ( I am posting this questions at a couple of places since I dont know where it would fit)



I am trying to display the x axis label for a line chart as Mon-YYYY (Jan-2006 Feb-2006 etc).

However I also want the labels to be sorted correctly.
which means it should be Jan-2006, Feb-2006, Mar-2006 etc.

The problem is that since the fields are in text format, it sorts differently than when it is a date field.


Does anybody know how I can achieve both (sort it by month , but display it in text)

Any help is appreciated on this.

(remember this is a line chart)


thanks very much

 

[lbass]

No, you shouldn't post in multiple forums. I just answered your other post.

-LB