Paynter Charts – Advanced Views in JMP Pareto and Graph Builder Charts

scwise · Nov 16, 2022 05:31 PM

Paynter Charts – Advanced Views in JMP Pareto and Graph Builder Charts

Hyde Miller & Scott Wise, JMP Technical Resources

Updated 11/16/22

Click here for access to featured graphs and data on JMP Public: https://public.jmp.com/spaces/ALLUSERS/posts/K1T_MNyX0ftx3YsndjwMn/reports

Challenge

Have you ever wanted to go beyond standard Run, Bar and Pareto Charts to visualize performance over time? Marvin (Marv) Paynter came up with such a graph in the 1980’s at Ford Motors to show the effectiveness of their Correct Action Systems. Called a Paynter Chart, this graph combines the best features of Run, Bar and Pareto Charts to show how things are performing over time among total count and failure subgroups. The great news is JMP 17 offers two ways to generate a Paynter Chart, both as options in the Pareto Plot and the Graph Builder platforms.

Case Study: Failure GB Data

Modern semiconductor manufacturing seeks to produce even smaller and more advanced silicon computer wafers. Over several days the count of failures by cause were recorded. Typical failure causes were from contamination, corrosion, doping, metallization, miscellaneous, oxide defect and silicon defects. A Paynter Chart graph is desired to allow for visual drill down of failure performance over time.

Paynter Plots in Pareto Plot Platform

Improvements in the Pareto Plot Platform in JMP 17 now allow the building of Paynter Plots. To build this graph:

Data Import & Platform Open:

Open the Failure GB.jmp data file
Start the Quality and Process -> Pareto Plot platform dialog

Pareto Platform Settings:

Put “Causes” in the Y, Cause area
Put “Day” in the Subcategory
Put “Count” in the Freq
Click OK to generate the Pareto Plot

From the Report Window:

Right Click under the Pareto Plot Red Triangle and select “N Legend” to get a total count of all N (Failure Causes)

Optional Settings:

Right Click on the Pareto Markers in the Legend area -> Marker -> Marker Shape = *
Right Click on the Cumulative % Curve in the Legend Area -> Line Color -> Blue
Right Click on the Total Count Curve in the Legend Area -> Line Color -> Red
Right Click on the left Y Axis, Select Axis Settings, then check the Major Grid Line option
Right Click on the bottom X Axis, Select Axis Settings, then check the Show Grid option

This generates a combined view that shows the count of Total Causes via a Line Chart, side-by-side Bar Chart of Causes by Day, and a descending Pareto Chart by Cause with a Cumulative % Curve.

Benefits of the Pareto Plot Platform

Making a Paynter Chart using the JPM 17 Pareto Plot platform is the fastest way (least number of steps) and offers many unique features. One of these is that the Cumulative % Curve (blue line) is reflective of the count of all the individual Cause subgroup bars, not just based off the total Cause amount like with the Total Count Curve (red line). Also, this platform automatically synchs both the left and right Y axis to reflect the true relationship between the two. This synching is very helpful if you plan on zooming in on the graph. If not desired, this can be unchecked under the Pareto Plot red triangle option of “Synchronize Y Axes”.

Paynter Plots in Graph Builder Platform

A Paynter Plot can also be created in the Graph Builder platform. To build this graph:

Data Import and Platform Open

Open the Failures GB.jmp data file
Start the Graph Builder Platform

Graph Builder Initial Set-Up

Put “Count” onto the left Y Axis
Put in another “Count” into almost the exact same spot (slightly into the body of the graph) on the left Y Axis to get a Count & Count
Put “Causes” on the X Axis
Put “Day in the Overlay area
Right Click in the Left Y Axis (Count & Count) and “Move Right” the second Count
Right Click in the Graph and change Points (right) to Line (Right)
Right Click in the Graph and Add -> Line element
Right Click in the Graph and Add -> Bar element

Set the Ordering

Right Click on X Axis -> Order By -> Count, descending
Right Click on X Axis -> Order Statistic -> Sum

Adjust Element Panel Settings (bottom left of the graph)

In the Points section, Summary Statistic = Sum and uncheck the Variables -> Overlay (Day)
In the Line (right) section, Summary Statistic = Cumulative Percentage and uncheck the Variables -> Overlay (Day)
In the Line section, Summary Statistic = Sum and uncheck the Variables -> Overlay (Day)
In the Bars section, Summary Statistic = Sum, and ensure Bar Style = Side by side

Align the Axes

Click on Count name in the right Y Axis and rename as “Cum Percent”
Right click in the Graph and Add -> Caption Box
In the bottom left part of the Caption Box section, Summary Statistic = Sum, X Position = Left and uncheck the Variables -> Overlay Day
Right click in the left X Axis, select Axis Settings, and set the Maximum to the Count Sum (in this case Sum = 268 total failures) to help us synch with the Cum Percent scaling on the right Y Axis
Right click in the left X Axis, select Axis Settings, and set the Increment = 50

Formatting and Labeling (Optional):

Right Click on the Legend area -> Marker -> marker shape = *
Right Click in the Legend Settings, change name of points Sum = “Pareto Markers”, red line Sum = “Total Count Curve”, blue line Sum % = “Cumulative % Curve”
Right Click in the Legend Settings, and reorder to legend items as desired
Right Click on the left Y Axis, select Axis Settings, then check the Major Grid Line options
Right Click on the bottom X Axis, select Axis Settings, then check Show Grid

Benefits of the Graph Builder Platform

Making a Paynter Chart using the Graph Builder platform does take more steps but offers more control of the final view. One of the only differences from the Pareto version is that due to the Overlay usage, the Graph Builder’s Cumulative % Curve (blue line) is reflective of the total Cause, which is the same way we calculate the Total Count Curve (red line). But most importantly the Graph Builder platform offers that ability to mix and match many different types of graph elements, as well and additional formatting setting options that are not all available on the Pareto Platform.

How to Read the Paynter Chart

The Total Count Curve in the Line portion of the chart gives us a look at the largest contributions of the Contamination and then the Oxide Defects. The Cumulative % Curve in the Pareto portion of the chart shows us that Contamination and Oxide Defects alone contribute around 70% of all recorded failure causes.

If we zoom in a little bit to view just the Bar Chart of Causes by day, we can not only see the leading causes that need more work (like with Contamination), but also can see where we can see where some improvement reduction efforts may be working over the time (like with Oxide Defects).

No matter which platform in JMP you choose, the Paynter Chart will add another great combination graph to your toolkit to best tell the story in your data!

Click here for access to featured graphs and data on JMP Public: https://public.jmp.com/spaces/ALLUSERS/posts/K1T_MNyX0ftx3YsndjwMn/reports