If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
xy scatter, missing one y
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 |
#2
|
|||
|
|||
xy scatter, missing one y
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" wrote in message ... 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 |
#3
|
|||
|
|||
xy scatter, missing one y
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" wrote in message ... 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 |
#4
|
|||
|
|||
xy scatter, missing one y
Only if a linear trend
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Boone" wrote in message ... 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" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Scatter Chart Axis as text in C# Web appl | Pavr1 | Charts and Charting | 1 | March 31st, 2005 05:28 AM |
Missing emails from Inbox | Stephanie | General Discussion | 0 | January 14th, 2005 03:31 PM |
missing radio button on Insert Address Dialog - inserting outlook contacts into Word | Lucian Sitwell | Contacts | 3 | December 28th, 2004 11:29 PM |
Report with Multiple Scatter Charts | Debbie | Setting Up & Running Reports | 1 | December 9th, 2004 04:36 AM |
Help with report...need to list if any info was missing from application. | Jacqueline | Setting Up & Running Reports | 2 | June 3rd, 2004 01:38 PM |