Trying to Create an np Chart in Excel?

Create a np Chart by running QI Macros:

  1. Select your data.
  2. Click on QI Macros menu > Control Charts (SPC) > Attribute (c,np,p,u,g,t) > np.
  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.

Use np Charts when counting defective items / constant sample size

The np Chart is useful when it's easy to count the number of defective items and the sample size is always the same. Examples might include: the number of defective circuit boards per 1000 or incorrect invoices per each sample of 50.

Example of np Chart data

np chart data example

Example of an np Chart created using QI Macros

np chart in Excel

It's Easy to Draw an np Chart in Excel Using QI Macros

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


Run a Macro on
Data You Have Already Collected

  1. Select your data.
  2. Click on QI Macros > Control Charts (SPC) > Attribute (c,np,p,u,g,t) > np.
  3. QI Macros does the math and draws the chart.
  4. QI Macros turns unstable points or trends turn red. These should be investigated.

Watch an np Chart created with our macro:

Input Data into a
Fill-in-the-Blanks Template

  1. Click on QI Macros > Control Chart Templates > Attribute (c,np,p,u,g,t) > np 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.

Example of QI Macros np Chart template:

np chart template in Excel

I looked at a number of alternatives (some much more expensive than QI Macros, some in the same price range); QI Macros was head and shoulders above the competition in price/performance.

- Robert Bamford
Software Systems Quality Consulting

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

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

Learn More...

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