Pre Control Chart in Excel
Use a Pre Control Chart When You Have Less Than 20 Data Points
QI Macros Add-in for Excel Contains an Easy to Use Pre Control Chart Template
How to Use the QI Macros Pre Control Chart Template in Excel
- QI Macros installs a new tab on Excel's menu.
- Click on the QI Macros menu tab and select Control Chart Templates, then Pre-control chart to open a template.
- Enter the upper and lower specification limits into the data sheet at H1 and J1.
- Add data as you begin to run the process.
- Evaluate the process much like you would a control chart. Most points should land in the green or yellow. Too many in the red: Danger! You may miss customer specifications.
Tip: Format Y axis: You may need to change the max and min amounts on the Y axis to properly display the areas for each color band. Just right click on the Y axis and select Format Axis then Axis Options.
QI Macros Pre Control Chart Template for XbarR data with up to five samples.
Why Choose QI Macros Over Other Control Chart Software?
Affordable
- Only $249 USD - 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
