Hi,

You can add the lines to the chart by using extra data series.
Here is a collection of examples.

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

Cheers
Andy

Amber wrote:
Is it possible to make a control chart with upper & lower control limits in
Excel?

Thanks

--

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