breakeven point

[bob]

i want to identify the breakeven point on a graph
i have cost on the y axis and stock price on the x axis
how would i draw a vertical line through the x axis that is the breakeven
value calculated in a cell.

some graphs dip down or up in the middle & i want to get get 2 breakeven
lines; one to the left & one to the right of middle.

or how would i plot a value on a graphs line that is the stocks price when
the cost is equal to breakeven.

thanks

 

[Debra Dalgleish]

Jon Peltier has instructions for adding lines to a chart:

http://www.peltiertech.com/Excel/Charts/ComboCharts.html#AddLine