Excel - Indicate intersection point on a two-line graph

Asked By Greg on 02-Dec-07 03:52 AM
Hi,

I have a simple line graph with two lines (line A and line B).  They
intersect at a given point (the break even point).  How do I indicate
on the graph that this is the break even point.  I know its very easy
to do with an arrow and text box.  However, I would like the arrow and
text box to move to a new intersection as I change the numbers around.

Thanks,
Greg




JohnMansfiel replied on 30-Nov-07 03:46 PM
Andy Pope has an example on his site which should help:

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

--
John Mansfield
http://cellmatrix.net
JohnMansfiel replied on 01-Dec-07 12:37 PM
Below is an example that shows how to use a textbox to show the breakeven
point in a breakeven chart:

http://www.cellmatrix.net/index.php/site/analysis/breakeven_chart_with_dynamic_label

--
John Mansfield
http://cellmatrix.net