I am using Access 2000-03. The graph is a subset to excel, but very close.

I have a Access Graph Chart with the Row Source set to:

"TRANSFORM Sum([Freq]) AS [SumOfFreq] SELECT [Personnel] FROM
[Rept#704_Joint_Personnel] GROUP BY [Personnel] PIVOT [RP];"

Currently, my graph order the personnel in Ascending order of Personnel. I
want to now order it by Descending Order of Freq.

In the query [Rept#704_Joint_Personnel], I have the following fields:
a) Freq
b) Personnel

Can someone please help me here!

Thank You,

Gary