Highlight Fluctuating Breakeven Point

[Steve D]

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?

 

[Andy Pope]

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