Extrapolation of a point on a graph/chart.

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!

"ExcelCretin" <ExcelCretin@discussions.microsoft.com> wrote in message
news:EDB60959-0E60-4772-960B-932CA5C9FEC6@microsoft.com...
>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

Thanks for the prompt response David, unfortunately I constructed a 'scatter'
with lines. does this make a difference?

"David Biddulph" wrote:

> "ExcelCretin" <ExcelCretin@discussions.microsoft.com> wrote in message
> news:EDB60959-0E60-4772-960B-932CA5C9FEC6@microsoft.com...
> >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
>
>
>

Use the LINEST function to get the coefficients in worksheet cells. For
more search the XL help for LINEST,

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <EDB60959-0E60-4772-960B-932CA5C9FEC6@microsoft.com>,
ExcelCretin@discussions.microsoft.com says...
> 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!
>