![]() |
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 |
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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 09:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com