How to draw a Pareto chart in Microsoft Excel? What is it's significance in Quality Management?

To build Pareto Chart using Excell Do the following

1. Set up your data. ...
2. Sort your data from largest to smallest amount. ...
3. Use the SUM() function to add your Amount range. ...
4. Create a Cumulative Amount column. ...
5. To automatically fill the rest of the column, double click the Autofill Handle.
6. Next, create a Cumulative Percent column.

Pareto Chart is very significant tool for Quality Managment as it derives you to solve 80% of the problems which is always due to 20 % of the causes. but using it depends on the type of buisiness you are woeking in and how you categorize your data. If you need any further assistance you can e-mail me

How to draw a Pareto chart in Microsoft Excel?

Please visit the following link

http://www.brighthubpm.com/templates-forms/8708-creating-pareto-charts-with-microsoft-excel/

What is it's significance in Quality Management?

http://blog.dataparcsolutions.com/using-pareto-charts-for-quality-control