Re: breakeven point

From: Debra Dalgleish (dsd_at_contexturesXSPAM.com)
Date: 04/24/04 

Date: Sat, 24 Apr 2004 07:53:01 -0400

Jon Peltier has instructions for adding lines to a chart:

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

bob wrote:
> 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. 

-- 
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Relevant Pages

  • breakeven point
    ... i have cost on the y axis and stock price on the x axis ... some graphs dip down or up in the middle & i want to get get 2 breakeven ... the cost is equal to breakeven. ...
    (microsoft.public.excel.charting)
  • Re: Automatic swap of x - and y - axis
    ... that would keep the chart in its intended configuration. ... Jon Peltier, Microsoft Excel MVP ... The graph changes not when data are entered, ... Are the values that were plotted on the horizontal axis now plotted ...
    (microsoft.public.excel.charting)
  • Re: Automatic swap of x - and y - axis
    ... of the chart, and a description of the problem, someone may be able to help. ... Jon Peltier, Microsoft Excel MVP ... by the time the graph is ... Are the values that were plotted on the horizontal axis now ...
    (microsoft.public.excel.charting)
  • Re: Automatic swap of x - and y - axis
    ... that would keep the chart in its intended configuration. ... Jon Peltier, Microsoft Excel MVP ... The graph changes not when data are entered, ... Are the values that were plotted on the horizontal axis now plotted ...
    (microsoft.public.excel.charting)
  • Re: Graphing points to the 10^-19
    ... Jon Peltier, Microsoft Excel MVP ... When editing the y axis the minimum value on automatic is 0 and the ...
    (microsoft.public.excel.charting)