How can I Order By in Access Graph Chart ?

G

Gary

I am using Access 2000-03.

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
 
D

Duane Hookom

Your chart doesn't have a Freq column to sort by. Your columns in the chart
row source should be Personnel and values of RP.
 

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 to order chart in descending order of Freq? 1
Help In Assigning a color for a value in a Pie Chart 3
How To Add Ordering To SQL For graph 4
Help to pick constant color to a value in a Pie Chart? 6
microsoft graph chart 3
How do I sort a listbox by field 17
Graph Column Headings 7
Bars in Bar Charts in an order 3

Top