Order of values in the Legend of a stacked bar graph (Crystal 9)

[PhilB2]

My stacked bar graph Legend, for a row that is ordered specifically and consists mostly of month names, sorts nearly correctly for one set of data (only a straggler is out of order), but for another, January appears after December. I've read threads in Google and in Tek-Tips, to no avail.

 

[NickieP]

Hi, If your data starts at the end of year 1 into year 2, could your groups be Year & month rather than Months (1 -12)?
This would make Jan(month 1 year 1) appear before Dec(month 12 year 2), where you just want Jan-Dec - regardless of year.
Instead of group by month, group by month number using Datepart:

DatePart ("m",{yourdatefield})Returns just the month number 1-12
so
DatePart("m",(currentdate)) returns 10

 

[PhilB2]

I should have been clearer that the values are literal strings, not dates, and do not correspond directly to dates. For this purpose, they could be "apple, box, cat, dog, 2015, 2016, xylophone". Also, my record selection criteria include only one year.

 

[NickieP]

Then I'd double check the source data.
Check there's not a space before the "J" in January.

 

[PhilB2]

For one set of data, January is in the right place; for another set, it appears after December. The field being reported on is a single selection field (drop-down).