How to have the bar chart list item in descending order by value

[maupiti]

Access 2003.

How to have the bar chart list item in descending order by numerical value and not by category name ?

On the graph

Y axis (vertical axis) is the numeric value
X axis (horizontal axis) is the name of the Defect_Category

On the query

Field: Defect_Category Department_Name Count
Table: Defect_Cat Defect_Cat Defect_Cat
Total: Group By Group By Sum
Crosstab: Row Heading Column Heading Value
Sort: Descending

I TRY TO PUT a sort by Descending order on the Field
Count, but it gives me an error.

If I put a sort by Descending order on the field
Defect_Category, then it will sort by descending order
in alphabetical order, which is not what I wanted.


///////////////////////////////////////////////

TRANSFORM Sum(Defect_Cat.Count) AS SumOfCount
SELECT Defect_Cat.[Defect Category]
FROM Defect_Cat
GROUP BY Defect_Cat.[Defect Category]
PIVOT Defect_Cat.Dept_Name;