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 3 spreadsheets: your original data sheet, the chart and an intermediate spreadsheet where all of the calculations are performed. To add data to an existing chart:

  1. Click on the intermediate data sheet (e.g., pdata1) and add the new data and labels in the rows under your old data.

    add data to control chart

  2. If necessary, use Edit/Copy and Edit/Paste to copy any formulas down to the new rows.
  3. Click on the chart or chart worksheet then click on 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 to the intermediate spreadsheet 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 the QI Macros pull down 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 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 are set up to take 50 data points. To add data to a template:

  1. 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.
  3. Once you have used all 50 rows, you will need to expand the template to take more rows.
    • First use Edit/Copy and Edit/Paste to copy the formulas down into the new rows.

      expand control chart formuals for new data

    • Next select the chart and select "Add Data to Control Charts" on the QI Macros pull down menu. Input the number of rows you just added.
  4. Re-run stability analysis whenever you have added new data by clicking on the chart and then clicking on the QI Macros pull down menu. Select "Analyze Stability" to run stability analysis on your data. Any unstable point or condition will turn red.

Learn More...

Create these charts and diagrams in just seconds using QI Macros for Excel...
Try It Now!