high-low lines

[Lynne]

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.

 

[Jon Peltier]

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]

Jon - thank you. You're a lifesaver!

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/
_______