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
|
|||
|
|||
What is a Range Chart
I've just been asked by my boss to create a range chart. I have no idea with
it is. -- DMM |
#2
|
|||
|
|||
What is a Range Chart
Google is your friend:
http://www.qualityamerica.com/knowle...NGE_CHARTS.htm http://www.qualityamerica.com/knowle...NGE_CHARTS.htm http://www.adamssixsigma.com/Glossar...glossary_R.htm www.qualitydigest.com/apr/spctool.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "soconfused" wrote in message ... I've just been asked by my boss to create a range chart. I have no idea with it is. -- DMM |
#3
|
|||
|
|||
What is a Range Chart
Okay, now I know what they are, how and why they are used, now how do I
create one? Thanks -- DMM "Jon Peltier" wrote: Google is your friend: http://www.qualityamerica.com/knowle...NGE_CHARTS.htm http://www.qualityamerica.com/knowle...NGE_CHARTS.htm http://www.adamssixsigma.com/Glossar...glossary_R.htm www.qualitydigest.com/apr/spctool.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "soconfused" wrote in message ... I've just been asked by my boss to create a range chart. I have no idea with it is. -- DMM |
#4
|
|||
|
|||
What is a Range Chart
It's a line chart, so put your relevant data into two columns (first column
for whatever is your X variable, second column for your range data). Help Excel by putting a label above the range column, while keeping thee cell above the X values column blank. Select the data and create a line chart. To get control lines, use a technique like this one: http://peltiertech.com/Excel/Charts/RunChtLines.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "soconfused" wrote in message ... Okay, now I know what they are, how and why they are used, now how do I create one? Thanks -- DMM "Jon Peltier" wrote: Google is your friend: http://www.qualityamerica.com/knowle...NGE_CHARTS.htm http://www.qualityamerica.com/knowle...NGE_CHARTS.htm http://www.adamssixsigma.com/Glossar...glossary_R.htm www.qualitydigest.com/apr/spctool.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "soconfused" wrote in message ... I've just been asked by my boss to create a range chart. I have no idea with it is. -- DMM |
#5
|
|||
|
|||
What is a Range Chart
Thank you Jon.
-- DMM "Jon Peltier" wrote: It's a line chart, so put your relevant data into two columns (first column for whatever is your X variable, second column for your range data). Help Excel by putting a label above the range column, while keeping thee cell above the X values column blank. Select the data and create a line chart. To get control lines, use a technique like this one: http://peltiertech.com/Excel/Charts/RunChtLines.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "soconfused" wrote in message ... Okay, now I know what they are, how and why they are used, now how do I create one? Thanks -- DMM "Jon Peltier" wrote: Google is your friend: http://www.qualityamerica.com/knowle...NGE_CHARTS.htm http://www.qualityamerica.com/knowle...NGE_CHARTS.htm http://www.adamssixsigma.com/Glossar...glossary_R.htm www.qualitydigest.com/apr/spctool.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "soconfused" wrote in message ... I've just been asked by my boss to create a range chart. I have no idea with it is. -- DMM |
Thread Tools | |
Display Modes | |
|
|