Is there a way to find the point of intersection of a trend line and another series on a chart in Excel? The other series may be another trend line or just the interpolated line drawn by Excel.
Get equations for both trendlines. Put them in the form
y = f(x). Set them equal to each other. Solve for
You would have to compute the slope of the line vs. every data point that you are looking at. Any data point that has a higher X axis value than the corresponding computed point on the slope would exceed it. You could optimize the search for this point by first computing your slope, then sorting your data points from the highest X axis value, in decending order, then interating through the list of data points and computing the corresponding X axis value of the trendline slope vs. the examined X axis value of the data point.