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