Show a break even point

[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

 

[Frank Kabel]

Hi Mark
don't use a line chart but a XY scatter chart (and combine the dot's
with lines). After this you can use a dummy series to achieve a
straight line at your excat calculated break even point. See
http://andypope.info/charts/averageline.htm
http://www.tushar-mehta.com/excel/charts/straight_lines/index.html
http://peltiertech.com/Excel/Charts/DummySeries.html#AddLine

 

[Mark]

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

You've answered it for me

Thanks
Mark

 

[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

 

[Frank Kabel]

Hi
if you want to link your axis scales to a cell have a look at the
following add-in:
http://www.tushar-mehta.com/excel/software/autochart/index.html

 

[Jon Peltier]

Link Chart Axis Scale Parameters to Values in Cells (VBA)
http://peltiertech.com/Excel/Charts/AxisScaleLinkToSheet.html

- Jon

 

[Mark]

Many thanks for your help. I'll try these as they look promising.

Mark