Pareto analysis and Pareto chart

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.