Create Pareto Chart with Microsoft Excel 2007

Here will show you how to create a pareto chart with Microsoft Excel 2007.

Step 1: Build a table with Defect/Item, Number of Cases, Accumulated percentage (ACCU %) & percentage (%).

Step 2: Highlighted the Defect, Cases & Acuu % then create a 2-D Column Chart in "Insert" Dialog.

Step 3: The chart should be like below. Don't worry about 2 bars in the chart.

Step 4: Select the red colour series (named Accu %). right click and select "Change Series Chart types...".

Step 5: Select the line style.

Step 6: Now you will see the accu% in line style.

Step 7: Now we are going to add in second axis for Accu % series. In "Format" Dialog, find the "Series 'ACCU %'" at the top left corner of panel.

Step 8: Changed it to "Series 'ACCU %'". Click on "Format Selection".

Step 9: Find "Series Option" and click on "Secondary Axis".

Step 10: Find "Line Style". Make sure to check the "Smoothed line".

Step 11: Click on Secondary Axis and light click to find "Format Axis...".

Step 12: Find "Axis Options" and change the "Maximum" from "Auto" to "Fixed" at 1.0.

Step 13: Your pareto should be ready.