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.
