Control Chart Templates with Scrolling Data

Are You Looking for a Control Chart that Will Scroll Through Your Data ?

  • Do you want to be able to look backwards and forwards through your data?

QI Macros now contain scrolling control chart templates for c, n, p, u, XmR and XbarR 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. c Chart.)
  3. The QI Macros control chart templates are actually made up of several worksheets. Click on the worksheet labeled Scrolling (e.g. c Scrolling.)

    control chart template options

  4. Input your data into the yellow input area.
  5. Below the chart is a scroll bar.
  6. Simply click on the arrows (above) or on the bar itself to move backwards and forwards through your data.
  7. If column A contains special formatting (e.g., dates), you may need to select column C (may vary by chart) and change the format:

  8. The c, np, p and u chart use all of the data to calculate limits. XmR and XbarR use the first 50 data points to establish limits.

Learn More About Control Chart Template Options ...

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