Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to make a shewhart chart
working on a QA,QC project for a start up lab and I need some pointers on
stats, as well as how to construct these specific types of charts. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to make a shewhart chart
Hi,
I had to google to find out what a Shewhart Chart is. OK now I know. I've used them before just didn't know what they were called. <g Jon Peltier shows you 2 techniques here on how to add horizontal lines. http://peltiertech.com/Excel/Charts/AddLine.html And here he explains how to add Standard Deviation and Mean lines. http://peltiertech.com/Excel/Charts/RunChtLines.html Jon uses a line chart in his example, however, I prefer to use an XY scatter. What you use depends on what you are analysing and also personal preference. HTH Martin " wrote in message ... working on a QA,QC project for a start up lab and I need some pointers on stats, as well as how to construct these specific types of charts. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to make a shewhart chart
In article , "MartinW" wrote:
Hi, I had to google to find out what a Shewhart Chart is. OK now I know. I've used them before just didn't know what they were called. <g Jon Peltier shows you 2 techniques here on how to add horizontal lines. http://peltiertech.com/Excel/Charts/AddLine.html And here he explains how to add Standard Deviation and Mean lines. http://peltiertech.com/Excel/Charts/RunChtLines.html Jon uses a line chart in his example, however, I prefer to use an XY scatter. What you use depends on what you are analysing and also personal preference. Also, if you want to see uneven x values (eg numbers of days) then XY scatter is your only choice. All the other chart types even out the intervals ... a serious trap for the unwary IMO ... or has this been fixed in xl 2007 ? " wrote in message ... working on a QA,QC project for a start up lab and I need some pointers on stats, as well as how to construct these specific types of charts. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to make a shewhart chart
If the dates are in a format Excel recognizes, then you can choose the
Time-Scale subtype of the Category type axis, and you will get axis spacing proportional to the passage of days. This has been available at least since Excel 97. Chart menu Chart Options Axes tab. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Bruce Sinclair" wrote in message ... In article , "MartinW" wrote: Hi, I had to google to find out what a Shewhart Chart is. OK now I know. I've used them before just didn't know what they were called. <g Jon Peltier shows you 2 techniques here on how to add horizontal lines. http://peltiertech.com/Excel/Charts/AddLine.html And here he explains how to add Standard Deviation and Mean lines. http://peltiertech.com/Excel/Charts/RunChtLines.html Jon uses a line chart in his example, however, I prefer to use an XY scatter. What you use depends on what you are analysing and also personal preference. Also, if you want to see uneven x values (eg numbers of days) then XY scatter is your only choice. All the other chart types even out the intervals ... a serious trap for the unwary IMO ... or has this been fixed in xl 2007 ? " wrote in message ... working on a QA,QC project for a start up lab and I need some pointers on stats, as well as how to construct these specific types of charts. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shewhart control chart using Excel | Charts and Charting in Excel | |||
how do I make a chart | Charts and Charting in Excel | |||
how to make a bar chart | Excel Discussion (Misc queries) | |||
How do I make a to do chart for every day of the week? | Charts and Charting in Excel | |||
how do you make a chart | Charts and Charting in Excel |