Control Chart Templates with Rolling Data

Are You Looking for a Control Chart that Will only Graph Your Most Recent Data Points?

  • Do you add new data every month but only want to see the most recent 12 months?
  • Do you add new data every day but only want to see the most recent 30 days?

QI Macros now contain control chart templates for rolling data for c, n, p, u and XmR charts. To use these templates:

  1. Click on the QI Macros menu and select SPC Charts.
    control chart template menu
  2. Click on one of the control chart templates to open it (e.g. XmR Five Pack.)
  3. The QI Macros control chart templates are actually made up of several worksheets. Click on the second worksheet labeled rolling (e.g. XmR Rolling.)

    control chart template options

  4. Input your data into the yellow input area.
  5. To the right of the chart there is a yellow input box labeled Rolling.
  6. Input the number of points you want graphed - lets say 12.
  7. Now even if your data contains 30 points, only the last 12 points will be graphed and used in the control limit calculations.
  8. If you add a new point, the chart and control limit calculations will roll off the 13th most recent point and add the new one.

Learn More About Control Chart Template Options ...

To create a Control Chart Rolling Templates using QI Macros...
Try It Now!