Sort order in a chart

[sam]

Can anyone tell me if it is possible/how to set the sort order in a chart. It
is in alphabetical order at them moment abd i can't seem to change the order
at all, same with the legend which instead of Mar, Apr May puts it as Apr,
Mar, May?

 

[sam]

worked it out.

 

[Larry Linson]

worked it out.

Care to share? Someone else may face the same problem and might be able to
use the same solution.

Larry Linson
Microsoft Access MVP

 

[Kristin]

If you right-click the chart and select Properties, you can change the Row
Source of the chart to include a sort order.