I am putting together some control charts and am wondering how I can extend
the UCL, LCl and mean lines to the end of my chart. Short of copying and
pasting the amounts for the 90 days that I am showing for the rest of my
data.

Hi
have a look at
http://andypope.info/charts/averageline.htm
http://www.tushar-mehta.com/excel/ch...nes/index.html
http://peltiertech.com/Excel/Charts/...s.html#AddLine

--
Regards
Frank Kabel
Frankfurt, Germany


Chris wrote:
> I am putting together some control charts and am wondering how I can
> extend the UCL, LCl and mean lines to the end of my chart. Short of
> copying and pasting the amounts for the 90 days that I am showing for
> the rest of my data.