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:

    weighted pareto chart data
  2. To create a Pareto Chart using QI Macros, just select the data (Use "Ctrl C" to select non-adjacent columns):

    select data
  3. Then, click on the QI Macros menu and select "Pareto Chart":

    pareto on menu
  4. QI Macros does all of the math and draws the Pareto Chart in seconds:

    weighted pareto
  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:

    unweighted pareto

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...

Reasons to Choose QI Macros to Draw Your Six Sigma Charts



  • Only $299 USD - less with quantity discounts
  • No annual subscription fees
  • Free technical support

easy to use

Easy to Use

  • Works right in Excel
  • Create a chart in seconds
  • Easy to customize & share charts

proven and trusted

Proven and Trusted

  • More than 100,000 users
  • In More than 80 countries
  • Five Star CNET Rating - Virus free