HELP-access chart-how to sort columns...

[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

 

[JerryDennison]

Click on the chart and open it's properties. Click the "..." next to the RowSource Property. This will open the query the chart is based on. Here you can change the sort order the numeric field to Descending.