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 contains scrolling control chart templates for most control charts.

To use these templates:

  1. Click on the QI Macros menu and select Control Chart Templates.
    control chart template menu
  2. Click on one of the control chart templates to open it (e.g. c Chart.)
  3. QI Macros control chart templates are actually made up of several worksheets. Click on the worksheet labeled "Scrolling" (i.e. c Chart Scrolling.)

    c chart template options

  4. Input your data into the yellow input area and the chart will automatically populate to the right.

    scrolling control chart template
  5. The template provides two ways to scroll through your data:
    1. Input the starting value in the "Start Cell" to the right of the chart (i.e. cell L2).
    2. Use the scroll bar below the chart. Click on the arrows or on the bar itself to move backwards and forwards through your data.
 

Tip: If column A contains special formatting (e.g., dates), you may need to select column C (may vary by chart) and change the format to match column A.

 

Note: 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 ...


Why Choose QI Macros Over Other Control Chart Software?

affordable

Affordable

  • Only $249 USD - less with quantity discounts
  • No annual subscription fees
  • Free technical support

easy to use

Easy to Use

  • Works right in Excel
  • Create a chart in seconds
  • Easy to customize & share charts

proven and trusted

Proven and Trusted

  • 100,000 users in 80 countries
  • Celebrating 20th Anniversary
  • Five Star CNET Rating - Virus free