Chart Axis label sort dilemma

[stretch66]

Hi All,

Have been trying to create a line graph that compares sickness levels for 2006 and 2007 by month but the problem that I have is that I cannot sort the month's into correct order because:

1. Obviously they are not alphbetical
2. Cannot sum totals in the last query if using actual dates instead on Month.
3. Have to use motnhs in the format Jan, Feb, Mar etc to that I can overlay figures for 2006 and 2007 on the same graph.

Anyone have any ideas out there!

 

[Rabbie]

You can always have an extra field with the Month number in it for sorting purposes and use the Month Name for display purposes.

 

[stretch66]

This is where my knowledge lets me down as I don't know how to do that.

 

[stretch66]

Not sure how it works but went back to the query and did Month Format([Field],"mmm") and then put another attribute in for sorting and it worked. Tried it before but couldn't get it??? Anyway works now.

Also if anyone wants to know how to change the legend in future as have seen a lot of people asking this just go to Row Source on the properties of the graph and then use the titles you want like this:

TitleWanted:[Field]

Easy as that !