Doing microhardness analysis, we need to identify a specific point of
the curve. So I need to know what is the x value that would correspond
to a specific and predifined Y value of the curve.

The usual way to express this would be to have an horizontal line from
this specific Y axis value going to the curve and then going down to
the X axis.

How can I do that with Excel?

Thanks for your help!


--
DrPepper
------------------------------------------------------------------------
DrPepper's Profile: http://www.excelforum.com/member.php...o&userid=28891
View this thread: http://www.excelforum.com/showthread...hreadid=486399

Do you know the X and Y and just want to illustrate the relationship, or are
you trying to determine one from the other? If it's the former, add a new
series with a single X,Y point, then add negative X and Y error bars with
error bar values of 100%. Then hide the point if you want by double clicking
on it and choosing No Markers from the Patterns tab.

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


"DrPepper" wrote in
message ...

Doing microhardness analysis, we need to identify a specific point of
the curve. So I need to know what is the x value that would correspond
to a specific and predifined Y value of the curve.

The usual way to express this would be to have an horizontal line from
this specific Y axis value going to the curve and then going down to
the X axis.

How can I do that with Excel?

Thanks for your help!


--
DrPepper
------------------------------------------------------------------------
DrPepper's Profile:
http://www.excelforum.com/member.php...o&userid=28891
View this thread: http://www.excelforum.com/showthread...hreadid=486399

If you can use an add-in and can accept piecewise linear interpolation,
see
Interactive Chart
http://www.tushar-
mehta.com/excel/software/interactive_chart_display/index.html

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...

Doing microhardness analysis, we need to identify a specific point of
the curve. So I need to know what is the x value that would correspond
to a specific and predifined Y value of the curve.

The usual way to express this would be to have an horizontal line from
this specific Y axis value going to the curve and then going down to
the X axis.

How can I do that with Excel?

Thanks for your help!


--
DrPepper
------------------------------------------------------------------------
DrPepper's Profile: http://www.excelforum.com/member.php...o&userid=28891
View this thread: http://www.excelforum.com/showthread...hreadid=486399

Thank you Jon for you help. In fact, I only have the y value. I tried
what you said for known values and it works great.
Thank you again and if you have a solution for the other case, it would
be appreciated too!

Just see Tushar Mehta reply, will try this too!
Thanks a lot!


--
DrPepper
------------------------------------------------------------------------
DrPepper's Profile: http://www.excelforum.com/member.php...o&userid=28891
View this thread: http://www.excelforum.com/showthread...hreadid=486399