How to order chart in descending order of Freq?

G

Gary

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
 
J

Jon Peltier

I don't know how you'd have to modify your SQL statement, and I don't
know for sure how Access does its charting. But I presume if the data
comes in sorted, the chart will present it sorted. If it comes in
unsorted, that's what the chart will show.

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I Order By in Access Graph Chart ? 1
Help to pick constant color to a value in a Pie Chart? 6
How To Add Ordering To SQL For graph 4
Help In Assigning a color for a value in a Pie Chart 3
Display order of Bar Chart 2
Pivot chart: wrong date order on horizontal axis 1
Chart order 1
Changing order of series 2

Top