ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   What is a Range Chart (https://www.excelbanter.com/charts-charting-excel/185514-what-range-chart.html)

soconfused

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

Jon Peltier

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




soconfused

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





Jon Peltier

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







soconfused

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