Trying to Draw a p Chart in Excel?

QI Macros Can Do It For You!

Draw a p Chart using QI Macros

  1. Select your data.
  2. Click on QI Macros menu > Control Charts (SPC) > Attribute > p.
  3. QI Macros will do the math and draw the graph for you.

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. The p chart is often referred to as a fraction defective chart.

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.

What's the difference between a p chart and u chart?

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


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

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:


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 chart using a p Chart template:

  1. Open a template: QI Macros > Control Chart Templates > Attribute > 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

QI Macros p Chart template contains these options


Learn More...

Stop Struggling with p Charts!
Start creating your p Charts in just minutes.

Download a free 30-day trial. Get p Charts now!

QI Macros Draws These Charts Too!