Creating Pareto diagrams in Excel:
1.
Order the data in your frequency
distribution table in descending order.
2.
Create a bar chart.
3.
Add a column
in your frequency distribution table that measures the cumulative
frequency.
4.
Select the plot area of the chart in Excel and Right click.
5.
Choose Select
series.
6.
Click Add
7.
Series name doesn’t matter.
You can put ‘Line’
8.
For Series
values choose the cells that refer to the cumulative frequency.
9.
Click OK. You should see two side-by-side bars.
10. Select the plot area of the chart and Right click.
11. Choose Change
Chart Type.
12. Select Combo.
13.
Choose the type of representation from the
dropdown list. Your initial categories should be ‘Clustered Column’. Change the second series, that
you called ‘Line’, to ‘Line’.
14.
Done.
