Pareto analysis and Pareto chart
How to draw chart:-
1) take values for "cause" in first column.
2) take percentage for "problems" in second column.
Note:- this column should be in descending order of values.
3) enter cumulative percentage values in third column.
4) insert a chart
5) select chart type "Line - column of 2 Axes"
6) provide the three columns data as inputs for the chart
7) place it in a proper position in the sheet.
How to edit the options in the chart:-
1) You can enter "Title", "X-Axis", "Y-Axis" headings. Font, color etc.. you can change
2) you can modify the text orientations.
3) double click on the x-axis, y-axis values for modfiying the range, min, max etc.. values.
Categorize and stratify such things as errors, defects, delays, customer complaints or any other measures of the resulting quality of your process so that you can identify different classes or types of problems. pareto chart
ReplyDelete