|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
June 20th 07, 07:08 PM
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 
|
| Ads |
|
#2
June 20th 07, 07:12 PM
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
June 20th 07, 09:04 PM
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
June 20th 07, 10:31 PM
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 >> >> >>
|
| Thread Tools | |
| Display Modes | |
|
|
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? | [email protected] | 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 |
Linear Mode
