+ Reply to Thread
Results 1 to 5 of 5

Breakeven chart - won't start at zero

  1. #1
    Registered User
    Join Date
    01-13-2007
    Posts
    2

    Breakeven chart - won't start at zero

    Hi guys.
    Desperate for some help in producing a breakeven chart for my assignment. I have a data table using the values given but the chart won't start at zero ie when sales are zero, variable costs are zero but fixed costs are 17500.

    I'm not very good at Excel - having been largely self-taught - so I would appreciate very simple instructions if anyone can help!!

    I hope I have attached a copy of the data table and graph to show what I've done.

    Many many thanks for anyone who can help.
    Attached Images Attached Images

  2. #2
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,196
    Quote Originally Posted by Doogle
    Hi guys.
    Desperate for some help in producing a breakeven chart for my assignment. I have a data table using the values given but the chart won't start at zero ie when sales are zero, variable costs are zero but fixed costs are 17500.

    I'm not very good at Excel - having been largely self-taught - so I would appreciate very simple instructions if anyone can help!!

    I hope I have attached a copy of the data table and graph to show what I've done.

    Many many thanks for anyone who can help.
    Hi,

    Not sure what you are asking for, if fixed costs are as shown, ie not zero, then there is no zero, the chart appears correct.

    Would you like to specify where you would like the 'zero' to be? - the only possibility from your .jpg would seem to be in the category x labels, currently 1 to 8, to re-number those as 0 - 7 then set 0 - 7 in a new column and define that column as your category x labels.

    more?
    ---
    Si fractum non sit, noli id reficere.

  3. #3
    Registered User
    Join Date
    01-13-2007
    Posts
    2
    Hi.

    Many thanks for the reply. I probably hadn't explained myself properly as I wanted a x,y value of 0,0 for sales and variable costs as with no sales, there should be no variable costs.

    Thanks to your reply I realised I hadn't set the X value properly as they should have been using the output column and then I changed it to a scatter graph and hey presto - it works!!

    So many thanks for your reply as it prompted me in the right direction.

    very very grateful to you for your help.
    Mandi

  4. #4
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    3,993
    Hi,

    Just for references purposes, if need be, break-even analysis explained and charted ...
    http://www.exceluser.com/solutions/breakeven.htm
    HTH
    Carim


    Top Excel Links

  5. #5
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,196
    Quote Originally Posted by Doogle
    Hi.

    I probably hadn't explained myself properly as I wanted a x,y value of 0,0 for sales and variable costs as with no sales, there should be no variable costs.

    Thanks to your reply I realised I hadn't set the X value properly as they should have been using the output column and then I changed it to a scatter graph and hey presto - it works!!

    So many thanks for your reply as it prompted me in the right direction.

    Mandi
    good to see that you managed to resolve your problem, and thanks for your response.

    ---

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1