Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
i made a plot graph connected by a line. now i need to find values on that
line. how? thanks. |
#2
![]() |
|||
|
|||
![]()
Two possible ways:
1. if you have the formula for the line, use it go calculate the reading. 2. If you have sample points on the line, but no formula, then you can use the FORECAST() function. If you have two points [x1,y1] and [x2,y2] and you also have a third x3, then FORECAST() will calculate y3 for you. The neat thing about FORECAST() is that it works equally well if x3 is between x1 and x2 or is outside of the range. -- Gary''s Student "sorrelponie" wrote: i made a plot graph connected by a line. now i need to find values on that line. how? thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to assign character (text) values to y-axis in a Excel chart? | Charts and Charting in Excel | |||
A 2 line text showing up in the Cell in Excel prints in 1 line | Excel Discussion (Misc queries) | |||
How do I find an unknown value on a line made from known data? | Excel Discussion (Misc queries) | |||
Excel Compare values in columns & display missing values in a new | Excel Discussion (Misc queries) | |||
in excel, how do I find which values doesn't have a pair? | Excel Discussion (Misc queries) |