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.
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?
Affordable
- Only $249 - less with quantity discounts
- No annual fees
- Free technical support
Easy to Use
- Works right in Excel
- Create a chart in seconds
- Easy to customize & share charts
Proven and Trusted
- 100,000 users in 80 countries
- Celebrating 20th Anniversary
- Five Star CNET Rating - Virus free
