coordinates of a point

[Guest]

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.

 

[Jon Peltier]

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
774-275-0064
208-485-0691 fax
(e-mail address removed)
http://PeltierTech.com/
_______

 

[Guest]

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

 

[Tushar Mehta]

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

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}