Thread: Identifying a specific point on both axis

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!

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" <DrPepper.1ypnup_1132348210.2064@excelforum-nospam.com> wrote in
message news:DrPepper.1ypnup_1132348210.2064@excelforum-nospam.com...
>
> 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 <DrPepper.1ypnup_1132348210.2064@excelforum-nospam.com>,
DrPepper.1ypnup_1132348210.2064@excelforum-nospam.com 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!