I have a line chart that shows 12 months of data and a trend line. I
computed the Upper & Lower Control Limits using the Standard Deviation. Is
there a way to put these lines on my charts so that when my boss looks at it
she can tell if one or more of the points are out of control?

Thanks In Advance
Wm.

William:

This link will show you how to build a control chart in Excel.

http://processtrends.com/pg_charts_control_chart.htm

....Kelly





"williamr" wrote in message
...
I have a line chart that shows 12 months of data and a trend line. I
computed the Upper & Lower Control Limits using the Standard Deviation.
Is
there a way to put these lines on my charts so that when my boss looks at
it
she can tell if one or more of the points are out of control?

Thanks In Advance
Wm.

Thank You Very Much!!
Wm.

"Kelly O'Day" wrote:

William:

This link will show you how to build a control chart in Excel.

http://processtrends.com/pg_charts_control_chart.htm

....Kelly





"williamr" wrote in message
...
I have a line chart that shows 12 months of data and a trend line. I
computed the Upper & Lower Control Limits using the Standard Deviation.
Is
there a way to put these lines on my charts so that when my boss looks at
it
she can tell if one or more of the points are out of control?

Thanks In Advance
Wm.