Control Chart Template - Center Line Based on Average

The QI Macros default control chart template uses the average of your data to calculate the center line on your control chart. The 1 and 2 sigma lines and the upper and lower control limits are derived from this average.

To use a control chart template:

  1. Click on the QI Macros menu and Control Chart Templates.
    control chart template excel
  2. Click on one of the control chart templates to open it (e.g. XmR, XbarR, XbarS, Levey Jennings.)
  3. The control chart using the average line is the default and is usually the worksheet that is the farthest tab to the left (e.g. XmR Individuals Chart.)
    control chart template options
  4. Data input areas are shaded in yellow. As you input data, the charts populate to the right.

    control chart template in excel
  5. The X chart templates have input areas to define spec limits for the histogram.
Learn more about QI Macros control chart template options.

Why Choose QI Macros Over Other Control Chart Software?

affordable

Affordable

  • Only $249 USD - less with quantity discounts
  • No annual 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