Formats and Calculations Unique to the p Chart

p Chart UCL Limited to 100% Since it is a Fraction Defective Chart

Since the p chart is a fraction defective chart, the UCL is limited to 100% and the LCL is limited to 0%

p chart with UCL ceiling of 100%

p Chart Calculations for Small Sample Sizes

In certain cases, the standard formulas for control limits on the p chart cannot be used. This condition exists when:

n × pbar < 5

QI Macros p chart template contains a tab for these instances:

p for np 5

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.):


Why Choose QI Macros Over Other Control Chart Software?

easy to use

Fast and Easy to Use

  • Works right in Excel
  • Create charts in seconds
  • Easy to customize & share charts
  • Free Training Anytime

proven and trusted

Proven and Trusted

  • More than 100,000 users
  • In More than 80 countries
  • Five Star CNET Rating - Virus free



  • Only $349 USD
    Quantity Discounts Available
  • No annual subscription fees
  • Free technical support