Show a break even point

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

I have a series of profits from various scenarios in a line chart. It draws
a upward sloped line. I want to mark the break even point with a line on the
X axis. (naturally I can get one on the Y axis easy, but that is no good)

I made a series of nulls and put a -10 at about the point of the break even
point in the series and have a drop line at that point. It sort of works,
but it is too approximate.
i.e. break even of 7.4 and my X axis is in increments of 10, so the break
even presently shows at 10 (not 7.4), which is no good.

Any good ideas?

Mark
 
Many thanks
I was just think about this and wondering if it would work.

You've answered it for me

Thanks
Mark
 
I have achieved what I wanted following these instructions thanks very much.

However, is there any method to have these scale correctly when the values
change? For example, I have a dynamic chart and the X values vary from 0-5
to 0-50.

Many thanks
Mark
 
Back
Top