View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
David Biddulph
 
Posts: n/a
Default Extrapolation of a point on a graph/chart.

"ExcelCretin" wrote in message
...
I have constructed a graph which consists of plots joined by a line (basic
line graph). How do i find the value of a point on that graph (if x = 0.37
then y = ?) other than printing the graph off and manually drawing the
lines
myself? Any pointers would be most welcome!


If you've fitted a straight line, use the LINEST function to get the
gradient and intercept of that line, and then use those coefficients to work
out the y value for your x value.
--
David Biddulph