xy scatter, missing one y

[Boone]

I have 2 series (x,y) of 11 numbers than I can scatter plot and insert a
trend line on. My problem is that I have a 12th x value with no corresponding
y value. how can I find the y value in the trend? and put it on the graph?

Graphically, I need to extend a verticle line up from the 12th x axis
coordinate up to the intersection with the trend line from the first 11.

Thanks

[Bernard Liengme]

Would take toooooo long
Send me private email and I'll send you a file
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Boone" <[email protected]> wrote in message
news:[email protected]...
>I have 2 series (x,y) of 11 numbers than I can scatter plot and insert a
> trend line on. My problem is that I have a 12th x value with no
> corresponding
> y value. how can I find the y value in the trend? and put it on the graph?
>
> Graphically, I need to extend a verticle line up from the 12th x axis
> coordinate up to the intersection with the trend line from the first 11.
>
> Thanks

[Boone]

Thanks.

Up too late last night. Wouldn't =forcast() work to get the value of the
missing y and then base the trend line on only the 11 x,y pair series. That
way you'll see the relation of the unknown,x to the x,y trend line I do have.

See:
http://office.microsoft.com/en-us/as...090961033.aspx

Thanks.

Boone




"Bernard Liengme" wrote:

> Would take toooooo long
> Send me private email and I'll send you a file
> best wishes
> --
> Bernard V Liengme
> www.stfx.ca/people/bliengme
> remove caps from email
>
> "Boone" <[email protected]> wrote in message
> news:[email protected]...
> >I have 2 series (x,y) of 11 numbers than I can scatter plot and insert a
> > trend line on. My problem is that I have a 12th x value with no
> > corresponding
> > y value. how can I find the y value in the trend? and put it on the graph?
> >
> > Graphically, I need to extend a verticle line up from the 12th x axis
> > coordinate up to the intersection with the trend line from the first 11.
> >
> > Thanks
>
>
>

[Bernard Liengme]

Only if a linear trend
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Boone" <[email protected]> wrote in message
news:[email protected]...
> Thanks.
>
> Up too late last night. Wouldn't =forcast() work to get the value of the
> missing y and then base the trend line on only the 11 x,y pair series.
> That
> way you'll see the relation of the unknown,x to the x,y trend line I do
> have.
>
> See:
> http://office.microsoft.com/en-us/as...090961033.aspx
>
> Thanks.
>
> Boone
>
>
>
>
> "Bernard Liengme" wrote:
>
>> Would take toooooo long
>> Send me private email and I'll send you a file
>> best wishes
>> --
>> Bernard V Liengme
>> www.stfx.ca/people/bliengme
>> remove caps from email
>>
>> "Boone" <[email protected]> wrote in message
>> news:[email protected]...
>> >I have 2 series (x,y) of 11 numbers than I can scatter plot and insert a
>> > trend line on. My problem is that I have a 12th x value with no
>> > corresponding
>> > y value. how can I find the y value in the trend? and put it on the
>> > graph?
>> >
>> > Graphically, I need to extend a verticle line up from the 12th x axis
>> > coordinate up to the intersection with the trend line from the first
>> > 11.
>> >
>> > Thanks
>>
>>
>>