What is a Range Chart

[soconfused]

I've just been asked by my boss to create a range chart. I have no idea with
it is.

 

[Jon Peltier]

Google is your friend:

www.qualityamerica.com/knowledgecente/knowctrXBAR__RANGE_CHARTS.htm
www.qualityamerica.com/knowledgecente/knowctrMOVING_AVERAGE___RANGE_CHARTS.htm
www.adamssixsigma.com/Glossary_of_terms/six_sigma_glossary_R.htm
www.qualitydigest.com/apr/spctool.html

- Jon

 

[soconfused]

Okay, now I know what they are, how and why they are used, now how do I
create one?

Thanks

 

[Jon Peltier]

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

 

[soconfused]

Thank you Jon.
--
DMM

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
_______