Numerical order in calculated value graph

[Guest]

I have created a simple graph from a query that calculates the needed values.
The bars in the graph are obviously showing up in order as they appear in the
SQL statement. I need to get the catagories to show up in order of their
value, Highest to lowest. Is there anyway to do this?

Right now values show up such as
20,30,10,10,5,15

and i need
30,20,15,10,10,5

thanks

 

[John Vinson]

I have created a simple graph from a query that calculates the needed values.
The bars in the graph are obviously showing up in order as they appear in the
SQL statement. I need to get the catagories to show up in order of their
value, Highest to lowest. Is there anyway to do this?

Right now values show up such as
20,30,10,10,5,15

and i need
30,20,15,10,10,5

thanks

Is there an Order By in your SQL statement?

Obviously, since you chose not to post it, I can't suggest what it
should contain, other than to say that you must sort by the desired
field rather than leave the sorting to default.

John W. Vinson[MVP]