how to plot a break even chart

Please how do I plot a break even chart as the one attached herein?

Originally Posted by NeedForExcel

Hi,

There is nothing attached

https://www.excelforum.com/attachment.php?attachmentid=572230&stc=1&d=1525350631

Originally Posted by Daotor

https://www.excelforum.com/attachment.php?attachmentid=572230&stc=1&d=1525350631

Please see the attached

Originally Posted by MrShorty

Your picture looks like a basic scatter or line chart. Help file for scatter and line charts: https://support.office.com/en-us/art...5-104a9018b86e I would expect you to A) compute the data for chart in the spreadsheet, then B) create the scatter/line chart from that data. Are you having trouble computing the data in the spreadsheet, or are you having trouble creating the chart?

The problem I think is to compute the data, especially the vertical data.

Originally Posted by MrShorty

I am not in financials, so I don't know how one would typically compute break even (other than the most basic income-expense=0). Before worrying about the Excel programming side of the problem, how would you compute "break even" with a pencil and paper and a calculator?

Thank you, break even is calculated as: In Sales Volume= Fixed Cost/1-Variable Cost/Selling Price. Eg. Where Fixed Cost=400000, Variable Cost=30, Selling Price= 50; =400000/1-30/50 =400000/1-6 =400000/-4 =1,000,000

Originally Posted by MrShorty

I am not understanding your math expressions, though I don't know if I need to. Which is your "x" variable in this expression (variable cost maybe?)? Make a column of the desired "x" variables, the enter the appropriate formula in an adjacent column. Then build your chart based on those two columns.

OK many thanks