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

Example of a p chart

p chart in Excel created with QI Macros for 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

control chart in excel

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

Why Choose QI Macros Over Other Control Chart Software?

affordable

Affordable

  • Only $249 - less with quantity discounts
  • No annual 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

  • 100,000 users in 80 countries
  • Celebrating 20th Anniversary
  • Five Star CNET Rating - Virus free

Learn More...