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 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.
>
>

[Lynne]

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.
> >
> >
>