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 the Excel 2007 and 2010 ribbon. To access the menu, look to the far right under Chart Tools.

    qi-macros-chart-tools
  4. After you click on QI Macros Chart, the control chart tools menu will show up on the far left. Next select "Add Data."

    add data to charts

  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 to control chart

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

    qi-macros-analyze-stability


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

    recalculate control limits
  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. Use the QI Macros pull down menu to select "Analyze Stability With Control Chart Rules." 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 ALL so that all input rows are visible.

    prepare control chart template to add new data

  2. Simply input data into the next blank row.
    easy to add data to control chart template
  3. 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?

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