View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Daniel Daniel is offline
external usenet poster
 
Posts: 354
Default 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