Hi,

You need to calculate the intersection point and then plot that as another
series with data label.
See this example.
http://www.andypope.info/charts/intersection.htm

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Steve D" wrote in message
...
I have a chart that is based on user input and depending on the value the
user enters the breakeven point will fluctuate. I have manually put a text
box in the graph with details about the breakeven point. I would like to
automate that so when the user changes inputs the text box is updated with
new information. Is this possible?
--
Thank You,
Steve