Here is some data; tow lines that cross
x y z
1 2 6.25
2 3 5.75
3 4 5.25
4 5 4.75
5 6 4.25
6 7 3.75
7 8 3.25
8 9 2.75
9 10 2.25
10 11 1.75
In E1 and F1 I use SLOPE and INTERCEPT to find m and c of the first data
series
In E2 and F2 ditto for second
In E3 I compute the x value where they intersect =(c2-c1)/(m1-m2)
=(F2-F1)/(E1-E2)
In F3 I compute the corresponding y value y =m1*x1+c1; =E1*E3+F1
Select E3:F3 and use Copy; clcik the chart; use Edit | Paste Special | New
SERIES with x-value in first column; clcik OK
Format he new data series (one point) as a circle
Format again and specify Data Labels
Format Data Label to show as many decimal point (2 is enough) as needed
You may need to delete the legend for Series 3
Careful: you must select both the makers and the text in the legend before
hitting Deelte
Otherwise you could loose a lot of work (Ctrl+Z might bring it back)
(save file first, in case you delete the series not just its legend)

Email me (addy from my website) if you want a sample file
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Sandra P" wrote in message
...
What I want to do is somehow label the breakeven point in a line chart. I
have 5 different lines that intersect (breakeven) at different points. In
other words, if line A & line B intersect at year 3.5, is there a way for
"3.5" to be displayed above the lines? Also, is there a way for the
intersection point to be circled, or in some other way made prominent?