Changing the sort/running order on a Chart

[efandango]

I have a chart with 3 fields, they are:

Run_No
Yes
No

at the moment it looks like this:

60 - -
50 - - -
40 - - - -
30 - - - - -
20 - - - - - -
10 - - - - - - -
5 6 7 8 14 16 28


But I want it to look like this:

60 - -
50 - - -
40 - - - -
30 - - - - -
20 - - - - - -
10 - - - - - - -
6 8 28 5 14 7 16


In the QBE grid, i cannot change the [Run_No] to 'non-Group' which means the
chart always sorts on the [Run_No], is there a way around this? It is
actually a 'combined' char showing both YES and NO next to each other, i
don't mind which order it sorts on, but would prefer the No's first.


This is my SQL:

TRANSFORM Count(*) AS [Count] SELECT Tbl_Scores_Running_Totals.Run_No FROM
Tbl_Scores_Running_Totals GROUP BY Tbl_Scores_Running_Totals.Run_No ORDER BY
IIf(answer_box=-1,"Yes","No") PIVOT IIf(answer_box=-1,"Yes","No") In ("Yes",
"No");