|
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! -- DrPepper ------------------------------------------------------------------------ DrPepper's Profile: http://www.excelforum.com/member.php...o&userid=28891 View this thread: http://www.excelforum.com/showthread...hreadid=486399 |
Identifying a specific point on both axis
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 |
Identifying a specific point on both axis
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 |
| All times are GMT +1. The time now is 03:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com