ok so i have this curve that follows no continual function..for random x
coordinates, how do i get the corresponding y coordinate?

(first time excel user, in case my question sounds incredibly stupid)

thanks

Hi anna m,

Try using simple linear interpolation. Note that it may not be appropriate
for your data, you will have to be the judge of that.

You can download a sample chart here
http://edferrero.com/ExcelCharts/tabid/102/Default.aspx Look for 'Reading
Interpolated Values'.

Ed Ferrero
www.edferrero.com

ok so i have this curve that follows no continual function..for random x
coordinates, how do i get the corresponding y coordinate?

(first time excel user, in case my question sounds incredibly stupid)

thanks

Hi,

You might play around with the Chart's built in trend lines and ask Excel to
display the equation it comes up with on the chart. On the chart select the
series and choose Chart, Add Trendline and go from there.

--
Thanks,
Shane Devenshire


"anna m" wrote:

ok so i have this curve that follows no continual function..for random x
coordinates, how do i get the corresponding y coordinate?

(first time excel user, in case my question sounds incredibly stupid)

thanks

Use the FORECAST function.
--
David Biddulph

"anna m" <anna wrote in message
...
ok so i have this curve that follows no continual function..for random x
coordinates, how do i get the corresponding y coordinate?

(first time excel user, in case my question sounds incredibly stupid)

thanks