ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Upper Control Limits (https://www.excelbanter.com/charts-charting-excel/95099-upper-control-limits.html)

williamr

Upper Control Limits
 
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.

Kelly O'Day

Upper Control Limits
 
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.




williamr

Upper Control Limits
 
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.






All times are GMT +1. The time now is 03:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com