These lines indicate variability outside the upper and lower quartiles, and any point outside those lines or whiskers is considered an outlier.

Add the values for a (constant) line as a new series.

On the Data tab, in the Analysis group, click Data Analysis. average and productivity (or NA() if negative) 3. Resulting Individuals control chart: We have seen this data earlier as a run chart. How to add upper and lower limits in excel chart Caution - control limits are computed from the process standard deviation - not from rational subsets: The upper (UCL) and lower (LCL) control limits are: Exponentially Weighted Moving Average Chart Summary for diameter sample Subgroup Sample Size Lower Limit EWMA Subgroup Mean Upper Limit Limit Exceeded 1 5 73. _ How to add upper and lower limits in excel chart