×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Finding Axis Intercepts of Graph Intersection points.

Finding Axis Intercepts of Graph Intersection points.

Finding Axis Intercepts of Graph Intersection points.

(OP)
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.

RE: Finding Axis Intercepts of Graph Intersection points.

Hi,

Are you plotting two functions or two sets of points?

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Finding Axis Intercepts of Graph Intersection points.

(OP)
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.

RE: Finding Axis Intercepts of Graph Intersection 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,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Finding Axis Intercepts of Graph Intersection points.

(OP)
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.

RE: Finding Axis Intercepts of Graph Intersection points.

Please post your chart source data.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

RE: Finding Axis Intercepts of Graph Intersection points.

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

RE: Finding Axis Intercepts of Graph Intersection points.

(OP)
Thanks for your replies. I'm going to experiment with this last group of functions to see if anything within them will get there.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close