Excel stops copying the formula when it reaches the last cell with adjacent data. Enter "=Average (C:C)-2.66*Average (A:A)" in cell D2 and copy the formula down the column to create the lower limit.

Follow the steps to make a Run Chart in Microsoft Excel: Run charts are used to monitor the performance of the process over time with a focus on process improvement; it displays the measurement of ...

Control charts usually present a graphic display of process stability and/or instability with time, from which the you can determine mean and standard deviation.