| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Chart empty with new data in the dynamic range chart. | Excel Discussion (Misc queries) | |||
| x y scatter chart series ranges reset to x(range) = y(range) | Charts and Charting in Excel | |||
| What is Range For Chart AutoFilter Range VBA? | Excel Discussion (Misc queries) | |||
| Can I use named range in data range box when creating pie chart? | Charts and Charting in Excel | |||
| Chart Range | Charts and Charting in Excel | |||
Linear Mode
