Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
create SPC chart with 3 sigma Upper/Lower control limit
Hi all
How can I create a Statistic Process Control chart with 3 sigma Upper control limit and 3 sigma Lower control limit. The chart must be updated with new data. For example sale vs month chart for sale department and I know some data for last year. Must be some where have this tutorial please respond with the link. Thks Daniel |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
create SPC chart with 3 sigma Upper/Lower control limit
http://peltiertech.com/Excel/Charts/RunChtLines.html
Change the formulas to get ±3 SD instead of ±SD. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Daniel" wrote in message ... Hi all How can I create a Statistic Process Control chart with 3 sigma Upper control limit and 3 sigma Lower control limit. The chart must be updated with new data. For example sale vs month chart for sale department and I know some data for last year. Must be some where have this tutorial please respond with the link. Thks Daniel |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
create SPC chart with 3 sigma Upper/Lower control limit
Hi Jon
THe link shows bad intructions, not fully expressed, created confusion. Can not follow but thanks for the respond. Daniel "Jon Peltier" wrote: http://peltiertech.com/Excel/Charts/RunChtLines.html Change the formulas to get ±3 SD instead of ±SD. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Daniel" wrote in message ... Hi all How can I create a Statistic Process Control chart with 3 sigma Upper control limit and 3 sigma Lower control limit. The chart must be updated with new data. For example sale vs month chart for sale department and I know some data for last year. Must be some where have this tutorial please respond with the link. Thks Daniel |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
create SPC chart with 3 sigma Upper/Lower control limit
Daniel -
Respond offline (remove capital letters from my posted email address) and let me know where you had difficulties with the tutorial. I will rewrite the instructions to make them clearer and more complete. Thanks, - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Daniel" wrote in message ... Hi Jon THe link shows bad intructions, not fully expressed, created confusion. Can not follow but thanks for the respond. Daniel "Jon Peltier" wrote: http://peltiertech.com/Excel/Charts/RunChtLines.html Change the formulas to get ±3 SD instead of ±SD. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Daniel" wrote in message ... Hi all How can I create a Statistic Process Control chart with 3 sigma Upper control limit and 3 sigma Lower control limit. The chart must be updated with new data. For example sale vs month chart for sale department and I know some data for last year. Must be some where have this tutorial please respond with the link. Thks Daniel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change from mixed caps and upper lower to all upper lower case | Excel Worksheet Functions | |||
Count occurence with user defined upper&lower limit. | Excel Worksheet Functions | |||
Upper/lower control limits? | New Users to Excel | |||
How can I display upper and lower control limits as a line? | Charts and Charting in Excel | |||
Function for upper and lower control limits? | Excel Worksheet Functions |