How can I have a chart display data

[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

 

[mikehoot]

If the chart is running off a qry you can sort the query to show your largest values in ascending order. The chart will then reflect this. You can use the timer function to trigger a requery to update new values.