Draw a p Chart in Excel

Use p Charts when counting defective items & the sample size varies

The p Chart is one of four attribute control charts used to evaluate the stability of a process over time using counted data. p charts are sometimes confused with u Charts.

Defective Items - p Charts

Each item is only counted once:
p chart of defective items

  • car doors that need to be repainted
  • bills that are wrong
  • incomplete shipments

Defects - u Charts

Each item can have more than one defect:
defects

  • scratches on a car door
  • errors on a bill
  • missing products in a shipment

p Chart Data Example

p chart data

Example of a p Chart

p chart in excel

Uneven control limits result from the varying sample sizes.


It's Easy to Draw a p Chart in Excel Using QI Macros

QI Macros adds a new menu to Excel and provides two ways to create charts:

run-macro-use-template

What your organization has done with the excel macros is great. It saves me a lot of time by not having to create the formulas and links. Your QI Macro's are better than most SPC specific software on the market. I have been using your macros since 1997.

- Chuck Whitaker
Nishikawa Standard Co.


Create a p Chart by running a macro:

  1. Select your data.
  2. Click on QI Macros menu > Control Charts (SPC) > Attribute (c,np,p,u,g,t) > p.
  3. QI Macros will do the math and draw the chart for you.
  4. QI Macros will also turn any unstable points or conditions red - these should be investigated.

Create a chart using a p Chart template:

  1. Open a template: QI Macros > Control Chart Templates > Attribute (c,np,p,u,g,t) > p Chart
  2. Input your data into the yellow shaded area.
  3. The chart is drawn as the data is input.
  4. Run stability analysis using the chart tools menu.
p chart template in excel

p Chart template options

Learn more about QI Macros control chart template options

p-chart-template-tabs


Change the Y-Axis Multiplier:

  • Located to the right of the chart, this functionality allows you to change the multiplier. This automatically changes the y-axis value (e.g. 1, 10, 100, etc.):

y-axis-multiplier


Toggle Between p Chart and p' Chart:

  • Specifically offered in the p Chart macro, you can toggle between a p Chart and a p' Chart by inputting either "False" (p Chart) or "True" (p' Chart). This option is located to the right of your chart:

p-prime-toggle


Error Bars not Extending on your Template

If you have created a skyline template and the error bars are not extending, below are instructions on how to update your file accordingly:

  1. If your template is formatted to Wavy Control Limits, convert them to Skyline Control limits within QI Macros by first selecting your chart. From the QIMacros Chart portion, select the "Convert SkyLine/Wave" drop-down and click "Convert Wave to Skyline."
  2. Next, click any point on your Upper Control Limit and choose "Format" from the Excel ribbon.
  3. Then, select "Series UCL X Error Bars" from the Chart Area drop-down:
  4. p u templates error bar chart area selection

  5. Once you have done so, click the "Format Selection" button and then select "Specify Value" from the Format Error Bars section:
  6. p u template error bar format selection button

    p u template specify value button

  7. When the "Custom Error Bars" window opens, update the Positive Error Value and Negative Error Value from $M$70 and $T$70 to $M$150 and $T$150 accordingly:
  8. p u template customer error bar prompt

  9. Repeat these steps for UCL Y Error Bars, LCL X Error Bars, and LCL Y Error Bars.

Learn More...


Why Choose QI Macros Over Other Control Chart Software?

affordable

Affordable

  • 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