Click here to view a video on how Pareto diagrams are made using SPC for Excel
If all you need to make are Pareto diagrams, look no further. Our SPC software makes Pareto diagrams and can easily update existing Pareto diagrams with new data. Plus we offer a Pareto diagram training module in PowerPoint that you can easily customize (Pareto Diagram Training). And our SPC software makes moving the Pareto to Word or PowerPoint easy -- one click and the chart is moved, perfectly sized -- no more copying, pasting and resizing!
For more information on Pareto diagrams, please see our June 2004 newsletter on Pareto diagrams on our website. The example below shows how to construct a Pareto diagram using the SPC for Excel software. There are four different options for data entry.
A company is monitoring returned goods and reasons for those returns. Data has been collected and we want to use a Pareto diagram to highlight returned goods by product and reason for return.
Option 1: Frequencies Already Totaled
The categories are in one column or row and the frequencies are in another column or row with the frequencies already totaled. The columns and the rows do not have to be adjacent to each other. The table below shows the data entered as columns.
| Products | Number of Returns |
|
A |
15 |
|
B |
25 |
|
C |
8 |
|
D |
2 |
Option 2: Frequencies Need to be Totaled
The categories are listed in a range on the spreadsheet. There is no list of unique categories, and the frequencies need to be determined. The data can be in multiple rows and columns. Empty cells can be included. The table below shows the data entered in a number of columns and rows. The program will total each unique entry and develop a Pareto diagram based on those totals.
|
Customer Did Not Need |
Customer Did Not Need |
Customer Did Not Need |
|
Broken |
|
Broken |
|
Wrong Quantity |
Wrong Quantity |
|
|
Wrong Quantity |
Wrong Quantity |
Wrong Quantity |
|
Salesman Ordered Wrong |
Salesman Ordered Wrong |
Salesman Ordered Wrong |
|
|
|
Wrong Quantity |
|
Wrong Quantity |
Wrong Quantity |
Wrong Quantity |
|
Broken |
Broken |
Broken |
|
Customer Did Not Need |
Customer Did Not Need |
Customer Did Not Need |
|
Salesman Ordered Wrong |
|
Salesman Ordered Wrong |
|
Wrong Quantity |
Wrong Quantity |
|
Option 3: Frequencies per Period in Columns
The categories are in one column and the frequencies are in columns. The frequencies are already summed by column (e.g., week). The data entry requirements are shown below. The data must be in columns. The program will total the results and develop the Pareto.
|
Category |
Week 1 |
Week 2 |
Week 3 |
|
Late Shipments |
10 |
7 |
8 |
|
Wrong Material |
8 |
5 |
3 |
|
Wrong Address |
4 |
3 |
6 |
|
Not Complete |
3 |
5 |
4 |
|
Wrong Price |
6 |
2 |
1 |
Option 4: Frequencies per Period in One Column
Similar to option 3 but the categories and frequencies are listed by rows instead of columns. The data entry requirements are shown below. The data must be in columns. The program will total the results and develop the Pareto diagram.
|
Week |
Product |
Number of Returns |
|
1 |
A |
4 |
|
1 |
B |
2 |
|
1 |
C |
12 |
|
1 |
D |
3 |
|
2 |
A |
0 |
|
2 |
B |
3 |
|
2 |
C |
1 |
|
2 |
D |
4 |
|
3 |
A |
4 |
|
3 |
B |
2 |
|
3 |
C |
5 |
|
3 |
D |
1 |
|
4 |
A |
8 |
|
4 |
B |
1 |
|
4 |
C |
10 |
|
4 |
D |
1 |
Once the data is entered, you select the Pareto diagram icon from the SPC Menu, complete the input form, and the Pareto diagram is developed.
To learn more about the many other tools in SPC for Excel and/or download the demo, click the link below.
For information on ordering SPC for Excel, click the link below. We offer a 30 day money back guarantee.