how do i add an x-y convergence drop line from y to x axis?
 

I have an excel graph where the x and y lines converge.
I want to be able to drop a line from that point to the x axis

Thanks, Paul.

how do i add an x-y convergence drop line from y to x axis?
 

Andy Pope shows how to get the intersection of two lines:

http://andypope.info/charts/intersection.htm

From the data point that is added at this intersection, use an error bar,
negative Y using 100% of the value, to draw the line to the axis.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Paulc" wrote in message
...
I have an excel graph where the x and y lines converge.
I want to be able to drop a line from that point to the x axis

Thanks, Paul.