Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 20th 07, 07:08 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 354
Default 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   Report Post  
Old June 20th 07, 07:12 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
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



  #3   Report Post  
Old June 20th 07, 09:04 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
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




  #4   Report Post  
Old June 20th 07, 10:31 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 6,582
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change from mixed caps and upper lower to all upper lower case Fish''s Mermaid Excel Worksheet Functions 3 October 13th 06 02:15 PM
Count occurence with user defined upper&lower limit. Chan Excel Worksheet Functions 4 August 18th 06 05:34 AM
Upper/lower control limits? bethcovey@gmail.com New Users to Excel 1 May 25th 06 04:31 PM
How can I display upper and lower control limits as a line? Ringo417 Charts and Charting in Excel 1 April 18th 06 08:38 AM
Function for upper and lower control limits? CaptAndy Excel Worksheet Functions 1 March 29th 06 03:09 PM


All times are GMT +1. The time now is 04:46 AM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017