View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default 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