## 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.

Are you plotting two functions or two sets of points?

Skip,

_{ Just traded in my OLD subtlety... for a NUance!}## RE: Finding Axis Intercepts of Graph Intersection points.

## RE: Finding Axis Intercepts of Graph Intersection points.

Then you have two more line plots:

1) (0,y), (x,y)

2) (x,0), (x,y)

Skip,

_{ Just traded in my OLD subtlety... for a NUance!}## RE: Finding Axis Intercepts of Graph Intersection points.

## RE: Finding Axis Intercepts of Graph Intersection points.

Skip,

_{ Just traded in my OLD subtlety... for a NUance!}## RE: Finding Axis Intercepts of Graph Intersection points.

I never really fully developed it, or used it for anything.

It may serve as a starting point, or simply as amusement.

## RE: Finding Axis Intercepts of Graph Intersection points.

SLOPEandINTERCEPTfunctions 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.