access chart how to sort columns

[gingergina]

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

 

[diversoln]

Hi Ginger,

I'm working on a database that will require a Pareto Chart too - so let me know how this works ....

Put a field for your Areas and a field for your Inefficiency in a select query. Then right mouse click to add the totals line in the field table. For the Ineffiency and Area, use Group By. Sort Desending on the Inefficiency.

Then base your chart on the query results. Requery prior to displaying your chart so that if the order needs to change, it will automatically re-sort.

Hope this helps

[This message has been edited by diversoln (edited 10-22-2001).]