What is a Range Chart

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

soconfused - 29 Apr 2008 16:11 GMT

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

Signature

DMM

Reply to this Message

Jon Peltier - 29 Apr 2008 16:44 GMT

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______

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

Reply to this Message

soconfused - 29 Apr 2008 16:56 GMT

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

Thanks

Signature

DMM

> Google is your friend:
>
[quoted text clipped - 13 lines]
> > with
> > it is.

Reply to this Message

Jon Peltier - 29 Apr 2008 17:05 GMT

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
_______

> Okay, now I know what they are, how and why they are used, now how do I
> create one?
[quoted text clipped - 19 lines]
>> > with
>> > it is.

Reply to this Message

soconfused - 29 Apr 2008 18:14 GMT

Thank you Jon.

Signature

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
[quoted text clipped - 35 lines]
> >> > with
> >> > it is.

Reply to this Message