ExcelBanter - View Single Post

soconfused

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