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
|