Sorting a legend in a line graph

[cjbrown815]

Hello,
how do I sort the legend in a line graph? I have three charts that are all the same, but from different facilities. I've managed to get the lines the same colors, but the legend is showing different sort for each. All grouping and record sorting is the same on all three. All the "on change of" fields are the same as well as the sort in there. I'm at a loss

REPORT LEGEND 1 (this would be the ideal sort order)
BN Cooling Water BOD
BN Cooling Water MID
BN Cooling Water EOD

REPORT LEGEND 2
JU Cooling Water EOD
JU Cooling Water BOD
JU Cooling Water MID

REPORT LEGEND 3
WY Cooling Water BOD
WY Cooling Water EOD
WY Cooling Water MID

Sort field used in upper level "on Change of"
@Prod Date and Sample ID - A
Formula
left({SAMPLE.DATE1} & " " & {SAMPLE.SAMPLE_ID},10)

-CJ

SQL2005// CRXIr2// XP Pro

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931