Add New Data Points to Control Charts

It's Easy to Add Data to QI Macros Control Charts

The process is different depending on how you create your control chart:

  1. Control Charts Created with a Macro
  2. Control Charts Created Using Control Chart Templates

Control Charts Created with a Macro

Add Data to an Existing Control Chart Tutorial Video

When you run a macro you end up with two spreadsheets: your original data sheet and a sheet with the chart as well as all of the calculations. To add data to the chart:

  1. Scroll down to the end of the existing data and input the new labels and data into the first blank rows:

    input area to add data to existing chart

  2. If necessary, use Edit/Copy and Edit/Paste to copy any formulas down to the new rows.
  3. Next, click on the chart to view the QI Macros chart menu. This menu is sometimes hard to find in the Excel 2013-2019 and Office 365 ribbon. To access the menu, look to the far right under Chart Tools:

    QI Macros Chart Tools menu
  4. Now select "Add Data" on the far left:

    chart tools menu

  5. Input the number of rows of data you just added and click OK. This function will change the "source data range" of the chart and will update the chart to display your new data:

    add data prompt

  6. Next rerun stability analysis on the chart. Click on the chart sheet. Use QI Macros chart menu to select "Analyze Stability". QI Macros will rerun stability analysis on your old and new data:


Recalculate Control Limits with New Data

If you want to recalculate your control limits to include the new data you have just added:

  1. Just click on the QI Macros chart menu and select "Recalculate UCL and LCL" found in the Process Changes drop-down menu:

    recalculate ucl lcl menu
  2. The macros will re-calculate the control limits including the new data you added.  
  3. Don't forget to rerun stability analysis using the new control limits. Click on the chart sheet and use the QI Macros menu to select "Analyze Stability." QI Macros will rerun stability analysis using the new control limits.

Add Data to Control Charts Created with a Template

Adding Data to Control Charts Created with a Template Tutorial Video

Control Chart templates will automatically recalculate the control limits and add data to the chart as it is input.

  1. When adding data to a template, make sure the menu in cell B1 is set to Select All so that all input rows are visible:
  2. prepare control chart template to add new data

  3. Simply input data into the next blank row:

    easy to add data to control chart template
  4. Re-run stability analysis whenever you add data by clicking on the chart and then clicking on the QI Macros Chart menu. Select "Analyze Stability" to run stability analysis on your data. Any unstable point or condition will turn red.

Learn More...

Why Choose QI Macros Over Other Control Chart Software?

easy to use

Fast and Easy to Use

  • Works right in Excel
  • Create charts in seconds
  • Easy to customize & share charts
  • Free Training Anytime

proven and trusted

Proven and Trusted

  • More than 100,000 users
  • In More than 80 countries
  • Five Star CNET Rating - Virus free



  • Only $329 USD
    Quantity Discounts Available
  • No annual subscription fees
  • Free technical support