access charts-how to sort-urgent

[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

 

[GingerR]

have you tried just going into the query your report is based on and sorting that column DESCENDING?

the chart should change as your data changes.