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.
First tab "Break Even Analysis," is the sheet where I'm trying to highlight the "intersection point" of the yellow and blue lines of the break even:
Essentially trying to dynamically plot the point circled in red as is shown in about minute 15 of this YouTube video for Excel: https://www.youtube.com/watch?v=7MxlVMzRxa8.