access chart sorting order-please advise

[AccessNovice]

How can I have a chart display data where the tallest columns begin on the left, and as they go right they get smaller (Pareto Chart). The y-axis represents percentage of inefficiency in a factory areas, the x-axis rep seven factory areas. A factory manager would like to see from left to right the more serious inefficiencies first...
Any way, including vba to sort the access chart's columns biggest first. Keep in mind that the seven areas each improve and get worse, so when the chart displays the 7 columns, can I get it to instantly redisplay accordingly.
mike 908 253 9550 x299
michael.lynn@us.gases.boc.com

 

[dawnd3]

In the report (graph) design go into the properties and click in the row source field. Then click on the build button "..." and in the query grid sort the value field decending. When you view your report your bars should be ordered tallest to smallest. Dawn

http://www.calliopeconsulting.net