Forum menu
Topic starter
If I have a chart in excel with a couple of trend lines extended, is there a way I can get excel to tell me where they intersect?
Posted : 30/03/2011 12:01 pm
Thinking aloud, if you get it to tell you the equations of the trend lines, can you not solve for X? Or put the two equations into the sheet and use Goalseek to do the solving for X - plug X back into either equ and have a coordinate (plug into other equation as well to confirm you have the correct intersect if the equations may predict multiple intersepts).
Posted : 30/03/2011 12:09 pm
as bristol says you can take the trend equations and solve for X.
use goalseek if you dont want to do it with algebra.
Posted : 30/03/2011 12:11 pm
Topic starter
cheers.
got the trend equations, and using vlookup on the ratio of results to find 1
Posted : 30/03/2011 12:14 pm
you can show equation of a trend line
Posted : 30/03/2011 12:29 pm