high-low lines

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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/
_______
 
Jon - thank you. You're a lifesaver!

Jon Peltier said:
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/
_______
Click to expand...
 
Back
Top