coordinates of a point

i drew an XY scatter with a smoothed line connecting between points. how can
i find the value of a specific point on my chart.
for example, i want to know the corresponding x-value of a y-value that i
have.

Not that there's any physical meaning to that smoothed curve Excel draws,
but it comes up often. The curve is a Bezier, and Brian Murphy has figured
it out:

http://www.xlrotor.com/Smooth_curve_...ample_file.zip

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
774-275-0064
208-485-0691 fax

http://PeltierTech.com/
_______


"bayan" wrote in message
...
i drew an XY scatter with a smoothed line connecting between points. how
can
i find the value of a specific point on my chart.
for example, i want to know the corresponding x-value of a y-value that i
have.

Hello, I have the same problem: I have completed my chart, but I thought I
could somehow enter a value for the x-axis and the program would interpolate
off the chart to find the y value. That's what I need. Thanks

"Jon Peltier" wrote:

Not that there's any physical meaning to that smoothed curve Excel draws,
but it comes up often. The curve is a Bezier, and Brian Murphy has figured
it out:

http://www.xlrotor.com/Smooth_curve_...ample_file.zip

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
774-275-0064
208-485-0691 fax

http://PeltierTech.com/
_______


"bayan" wrote in message
...
i drew an XY scatter with a smoothed line connecting between points. how
can
i find the value of a specific point on my chart.
for example, i want to know the corresponding x-value of a y-value that i
have.

If you can live with piece-wise 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 , BuickGN87
@discussions.microsoft.com says...
Hello, I have the same problem: I have completed my chart, but I thought I
could somehow enter a value for the x-axis and the program would interpolate
off the chart to find the y value. That's what I need. Thanks

{snip}