Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Finding Axis Intercepts of Graph Intersection points.

Status
Not open for further replies.

bhujanga

Programmer
Oct 18, 2007
181
US
Is there a way in excel to find the intersection of two line plots and create a line that goes from that point to the x and/or y-axis.
 
Hi,

Are you plotting two functions or two sets of points?

Skip,
[sub]
[glasses]Just traded in my OLD subtlety...
for a NUance![tongue][/sub]
 
The plots are driven by sets of points. The values of the points have been derived from functions, but as far as the Excel sheet knows they are just sets of points.
 
Well, if the points are derived from functions, then could you not solve where function 1 equals function 2 for x & y?

Then you have two more line plots:
1) (0,y), (x,y)
2) (x,0), (x,y)


Skip,
[sub]
[glasses]Just traded in my OLD subtlety...
for a NUance![tongue][/sub]
 
That could be done in this case, but we are trying to find a more general solution for when the function may not explicitly known but implied by a collection data. I am gathering, however, that Excel doesn't have a specific tool that does that. I was hoping it might be something they provided, similar to the trendline functionality that is built in that would plot the result automatically, thereby adjusting and replotting it whenever the data changed a little.
 
Please post your chart source data.

Skip,
[sub]
[glasses]Just traded in my OLD subtlety...
for a NUance![tongue][/sub]
 
Excel has SLOPE and INTERCEPT functions that give parameters for linear best fit function for (X, Y) datasets. Next you can solve system of two linear equations using excel functions: calculate determinat to test number of solutions (MDETERM),reverse matrix (MINVERSE, table array function), multiply matrix by matrix (MMULT, table array function).
The table array functions has to be entered by selecting proper output range (2x2 or 2x1 cells) and entered with CTRL+SHIFT keys (as standard array function).

combo
 
Thanks for your replies. I'm going to experiment with this last group of functions to see if anything within them will get there.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top