Jon,
Thanks for that page... I am going to try the stuff in it and see if it is
what I need. The lines I'm refering to are the Upper Control Limit(UCL),
Lower Control Limit(LCU)
and the center line is basically an average line. These lines are
automatically put in the chart by the StatPlus add-in I have for excel. These
are process control charts and when you create them there is no option for
creating them dynamically. With John's page I was able to get the xbar and
moving range charts to become dynamic but I lost the lines. They are a
critical part of the chart and the values that are computed for them is the
precise reason I need them in there. The UCL and LCL are the limits, positive
or negative, that I need for the spreadsheet. Basically it is all statistical
monitoring but I need them for what I am creating. I will definitely try the
methods from your site before I go any farther and let you know if it does
what I need it to do. Thanks for the assistance.
Regards,
Brian Sells