Create an np Chart in Excel
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.
Just need one chart? Let us do it for you, only $97 Click Here!
Example of np chart data
Example an np chart created using QI Macros
It's Easy to Draw a 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
Watch a np chart created by a macro:
Input Data into a
Example of QI Macros np chart template:
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
Why Choose QI Macros Over Other Control Chart Software?
- Only $279 USD - less with quantity discounts
- No annual subscription fees
- Free technical support
Easy to Use
- Works right in Excel
- Create a chart in seconds
- Easy to customize & share charts
Proven and Trusted
- More than 100,000 users
- In More than 80 countries
- Five Star CNET Rating - Virus free