Upper/lower control limits?

Hey all
I have this line chart (with one series) and that I need to put upper
and lower control limits on. How should I go about doing this? Also,
is there a way to find the standard deviation without using the formula
in a cell?
Thanks
-beth

Hi,

The following pages have examples of how to add lines.

http://peltiertech.com/Excel/Charts/AddLine.html
http://tushar-mehta.com/excel/charts...nes/index.html
http://www.andypope.info/charts/averageline.htm
http://www.processtrends.com/pg_char...ontal_line.htm

I think formula is the only way to determine SD.

Cheers
Andy

bethcovey@gmail.com wrote:
> Hey all
> I have this line chart (with one series) and that I need to put upper
> and lower control limits on. How should I go about doing this? Also,
> is there a way to find the standard deviation without using the formula
> in a cell?
> Thanks
> -beth
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info