Home » Key Tools » Pareto Charts » Weighted Pareto Chart

Weighted Pareto Charts to Demonstrate the Cost of Defects

How to Create a Weighted Pareto Chart

Open the Pareto Chart Template

To open the template, select the "Chart Templates" drop-down > and open "Pareto Chart":

Next, select the "Weighted Pareto Chart" tab:

Below is the Weighted Pareto Chart template found within QI Macros:

---

How to Manually Create a Weighted Pareto Chart

1. To create a Weighted Pareto Chart, you will need to calculate the weighted cost of defects. To do so, multiply the number of defects times the cost per defect to develop a weighted cost. In this example, we calculated the weighted cost (column D) by multiplying columns B and C:
   
   
2. To create a Pareto Chart using QI Macros, just select the data (Use "Ctrl C" to select non-adjacent columns):
   
   
3. Then, click on the QI Macros menu and select "Pareto Chart":
   
   
4. QI Macros does all of the math and draws the Pareto Chart in seconds:
   
   
5. Compare the weighted chart to the unweighted chart below. The weighted Pareto points to Location 6 as the most costly defect category. While the unweighted Pareto Chart below, points to Location 8 as having the most defects:
   
   

I really like the QI Macros. The Pareto Chart is worth the purchase price of the whole deal.

Mike Dean, Ellwood Texas Forge

---

Learn More...

• Watch Video of Creating a Pareto Chart using the QI Macros
• Summarize Data with a PivotTable and Create a Pareto with One Click
• Pareto Chart Template for Excel
• Paynter Chart Template

---

Reasons to Choose QI Macros to Draw Your Six Sigma Charts