high-low lines
 

I need to draw a line between the expected UCL and LCL for each set of values
on a comparison chart. Using the existing "high-low" line function, it draws
a line between the highest value and the lowest value. I may, for example,
have an actual value higher than the Upper Control Limit and it should not be
included in the line.

Can anyone help me? Thanks.

high-low lines
 

You could plot a point at the LCL (hide the point: format it with no
line and no marker) and add a Y Error Bar with the value UCL - LCL.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Lynne wrote:

I need to draw a line between the expected UCL and LCL for each set of values
on a comparison chart. Using the existing "high-low" line function, it draws
a line between the highest value and the lowest value. I may, for example,
have an actual value higher than the Upper Control Limit and it should not be
included in the line.

Can anyone help me? Thanks.

high-low lines
 

Jon - thank you. You're a lifesaver!

"Jon Peltier" wrote:

You could plot a point at the LCL (hide the point: format it with no
line and no marker) and add a Y Error Bar with the value UCL - LCL.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Lynne wrote:

I need to draw a line between the expected UCL and LCL for each set of values
on a comparison chart. Using the existing "high-low" line function, it draws
a line between the highest value and the lowest value. I may, for example,
have an actual value higher than the Upper Control Limit and it should not be
included in the line.

Can anyone help me? Thanks.