Not as a chart function, but in the sheet with the data you can use the
FORECAST function.
--
David Biddulph

"S Khadanga" <S wrote in message
...
In a XY chart, I require to extract the Y value corresponding to any X
value
and use this Y value for further claculation. In there any function of
method
of this?