how to create a control chart

[vgr]

Hi,
I've used trend lines to find the mean and average but for some reason I have not been able to set an upper and lower limit. without introducing a new column.
Please do let me know if there's a way around this.
Thanks

 

[mole999]

you could draw lines on the chart at the levels you need to display

I've never seen the data used twice to produce other values (though saying that i have managed to copy a chart to itself (copy / paste) maybe that is editable as extra ranges)

 

[oldbrewer]

you have found both the mean and the average - can you explain how?

the upper and lower limits are calculated from the variability of the data so col A could be raw data, col B the mean, col C the UCL and col D the LCL

highlight the 4 columns and draw your chart - it is that simple