Are you Looking for a Control Chart with Fixed Limits?

QI Macros has Fixed Limit Control Chart Templates

  • Do you need to evaluate a batch run against historical control limits.
  • Do you need to compare your data against spec limits established by your customer?

How to use QI Macros fixed limit control chart templates.

  1. Click on the QI Macros menu and then Control Chart Templates:

    control chart templates excel
  2. Click on one of the variable control chart templates to open it (e.g. XmR Five Pack, XbarR Six Pack, XbarS Six Pack).
  3. Click on the worksheet tab labeled "Fixed" (e.g. XmR Chart Fixed).

  4. Input your data into the yellow input areas.

    fixed limit control chart template in excel
  5. To the right of the control charts there are yellow input boxes to define the Upper Control Limit (UCL), the Center Line (CL) and the Lower Control limit (LCL). For variable charts you can do this for both the X chart and the Range chart:
  6. input fixed control limits


Learn More...


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

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

QI Macros Draws These Charts Too!