Tell me more ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.
up vote 0 down vote favorite

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.

share|improve this question
I do not understand what "trendline will cross another series" means. – Toc May 24 '10 at 13:32
A Trendline can be added to a series - basically a prediction of the data extended beyond the known data. I want to know exactly when the trendline will intersect another series or even another trendline. – Adrian May 24 '10 at 14:20

2 Answers

up vote 1 down vote accepted

Get equations for both trendlines. Put them in the form y = f(x). Set them equal to each other. Solve for x.

share|improve this answer
Is the equation available as an object then? - Excel calculates the trendline. – Adrian May 24 '10 at 10:18
For my current use - its just easier to look at the chart! - – Adrian May 27 '10 at 9:51
up vote 0 down vote

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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.