Create a Break Even Analysis Chart

This video show how to create a break even graph and how to calculate break even analysis in the worksheet. It not a complex formula because it it based on some provided fixed and variable costs that enable you to calculate the break even unit totals and dollar amounts with the per unit sales price. Once you create the table with the formula you can see the incremental amounts (or time) that are needed to get to break even. Once you've created this graph, it can be used as a template or the final output can be put into a PowerPoint for your presentation.
🔔 SUBSCRIBE to my channel ➜ goo.gl/wN3c3p
🏫 Excel Training ➜ www.exceltrain...
📚 Excel Books & Tech Gear ➜ www.amazon.com...
⚙️ Tools: Screencasting ➜ techsmith.z6rj...
⚙️ Tools: Microsoft Office ➜ microsoft.msaf...
⚙️ Tools: TubeBuddy ➜ www.tubebuddy....
📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!
🎁 If you find these videos useful and want to support my channel go to www.buymeacoff...
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF...
~-~~-~~~-~~-~

[@benorchard6583]

Mr. Doug H. This video was extremely helpful. Your instructions were perfect. Thank you for teaching the world how to use Excel!!!

[@jessicamohr5213]

I know this is an "older" video in the world of technology, but I needed it! Thank you so much! I had been working on this for days, but your easy step by step process helped break it down so that I could understand. Thank you!

[@DougHExcel]

Glad it helped!

[@GDHWL2001]

Thank you so much! I have been trying to make a breakeven chart for days! You made it so easy for me to understand!

[@DougHExcel]

Thanks GD2602 Videos, glad it helped!

[@shanoguyo3786]

This video was the best explanation there is for the subject. Thank you Sir!

[@DougHExcel]

Thanks for the kind words!

[@kathleenmcdaid6960]

Brilliant, straightforward, clear and so easy to follow. Thank you Doug. I completed my chart with confidence now. You make it so easy.

[@lalalagirl2352]

Thank you very much, verry very much! You saved my life! No seriously,we have this teacher who gave us a task bout this which we have no idea whatsoever, tomorrow is the deadline and i still dont know what to do, i went on to many vids but i found it lacking in some way, yours is great!thank you very much!

[@DougHExcel]

Hi lalala girl, glad you liked it, thanks for commenting!

[@michalsuski7069]

This is so comprehensive and well narrated. Thankyou - you did what my lecturers couldn't :)

[@DougHExcel]

Hi Michal Suski, glad you liked it, thanks for commenting!

[@joetheseventeenth]

Thanks man. Very simple and straight forward.

[@DougHExcel]

You're Welcome!

[@sitinyeto]

This is by far better explanation than the other videos I've seen...thank you.

[@DougHExcel]

Hi Cool boy, glad you liked it, thanks for commenting!

[@ComfortAgyekum]

clearer and better than what I knew before.

[@mommysabira2626]

when i get so confused about my task from lecturer i found this video and watching this vide.it is solving my problems.thanks..

[@DougHExcel]

Thanks Elvira Savitri, glad it helped!

[@zafarshamsi2377]

Excellent video. Clear demonstration and very easy to follow. Thank you.

[@sfox3255]

Simple and easy to follow. Thanks Doug.

[@DougHExcel]

You're welcome, thanks for the comment!

[@girishghadge8460]

Wow what an explanation and really very crisp and informative great work!!!

[@DougHExcel]

Thanks for the comment!

[@sagarwagh5911]

Thanks a lot to you! It was very helpfull for me to prepare BEP in my MBA assignment. Cheers to you

[@DougHExcel]

Glad it helped!

[@ErickaMusa]

Thank you so much for your time! You have no idea how much you helped me!
Blessings!

[@walikhanofficial7021]

You have explained it very well. I have finished one university project and for Break-Even analysis, i have followed your video. Thanks you so much

[@DougHExcel]

Thanks Wali Khan, glad it helped!

[@paulkabui6255]

I have always done break-even analysis but without knowing what it means. Now I am a Master. The creator of this video deserves highest price!

[@DougHExcel]

Thanks for the comment!

[@paulkabui6255]

Yes u deserve highest price!

[@lolab3401]

Help!

[@chrismckenna8379]

you really have done an excellent job of explaining this and making the information accessible. Thank you!

[@DougHExcel]

Thanks for the kind words!

[@amako16]

Amazing video! Many thanks for your time and help!

[@DougHExcel]

Glad it helped!

[@1122_FC]

Oh My god! You're better than my accounts professor. Thank you so much for the tutorial. Life Saver, haha!

[@jh1896]

Excellent video and very useful in my strategic management project. It has been a while since I did break even analyses and needed a reminder. The tutorial and in-depth detail (step by step) on the charts were also very helpful reminders! Thank you!

[@DougHExcel]

Glad you liked...thanks for the comment!

[@shubhamshetshirodkar895]

It really helped me so much and its so easy to understand. Very well explained.

[@DougHExcel]

Glad you liked

[@ivanabunjevacki4935]

A great video! Very helpful with simple and clear explanations that hit the target.

[@DougHExcel]

Hi Ivana Bunjevacki, thanks for the kind words!

[@abduhamdan]

It's actually sufficient for everyone to understand

[@DougHExcel]

Hi abdu hamdan, thanks for the comment!

[@alexclarke3078]

Top class video used it today in my business lesson for my exam coursework so thanks

[@DougHExcel]

Fantastic!

[@vincentgan7249]

Thank you. You're my hero!

[@DougHExcel]

Hi vincent jetz, thanks for the kind words!

[@SaltFactoryForeman]

This helped me a lot, thanks.

[@DougHExcel]

You're welcome!

[@ishraqiqbal4291]

It's an amazing video. Clearly explained!! Good job Doug... Appreciate it.!

[@manishbirdi]

Thanks a lot Doug! This video helped me a lot!

[@DougHExcel]

Glad it helped!

[@DougHExcel]

You're welcome!

[@josher3436]

Great video. Logical and informative. Thanks

[@DougHExcel]

You're welcome!

[@littlejack223]

thanks a lot man! thanks for taking step by step

[@bbbbbb3186]

Thank you!! Such a great and easy to follow tutorial!!

[@DougHExcel]

You're welcome!

[@bostaffarts]

Thank you very much for creating this sheet!

[@DougHExcel]

You're Welcome!

[@ndhulkhogan]

This was excellent! Thank-you!

[@DougHExcel]

Glad you enjoyed it!

[@reneehunt5402]

Thank you so much! This is explained so well and I even learned some more excel tricks. Excellent. I think colleges should use this for a tutorial. Very helpful!

[@lisab992]

thank you so much! what a life saver you were! only recommendations (but i figured out once you showed where legend etc was) was how to label the axis...

[@elizangelahall2246]

Thanks Doug!

[@DougHExcel]

You are welcome!

[@sawadheelad9193]

Nice.. You're my hero 😁

[@DougHExcel]

Hi Sawadheel Ad, thanks for the kind words!

[@bushrawalji9461]

Excellent Video! Very helpful..Thank you!

[@DougHExcel]

Hi Bushra Walji, thanks for the comment!

[@MrJazAfonso]

Great presentation,
Very useful video,
Thank you

[@crysellasmith7714]

This is brilliant and just what I was looking for. Thank you.

[@aahizam828]

YOU'RE A LIFE SAVER THANKS

[@nikossalavrakos6476]

Good work and very enlightening, thank you

[@DougHExcel]

Thanks for your kind words!

[@pepperjohnson2659]

Very easy to understand and follow...thank you

[@ariel_ba]

Thank you so much for your time!

[@DougHExcel]

You're Welcome!

[@alyssali6690]

really helpful! I did that with my master program paper. Thanks!

[@DougHExcel]

Glad it helped!

[@mariomorenojr6229]

Enjoyed this, I learned new tips, Thanks

[@DougHExcel]

You're welcome!

[@lisajames5881]

Very Helpful!!!!!

[@DougHExcel]

Thanks Lisa James, glad it helped!

[@d_i_k_s_h_a5017]

Its really helpful. Thank you soo much.

[@DougHExcel]

You're welcome!

[@lynetteklish3160]

This video is amazing! Thank you !! CVP!!

[@DougHExcel]

Hi Lynette Klish...you're welcome, glad you liked!

[@sebus212pl4]

thank you so much this was a really good and helpful video

[@DougHExcel]

You’re welcome!

[@vckarabia]

very nice explain

[@DougHExcel]

Hi mugavai Nanban, thanks for the comment!

[@Toolmamon]

Got it! I had to enter the data individually. I could not do it the way you were doing it

[@Toolmamon]

***** Yes!!! I had to go and individually pick each column and add them! That is the only way I could do the graph! I had forgotten how a pain in the ass excel could be when it came to doing graphs! Thanks!

[@ayuningkarimah5883]

Thank you so much. Your help me finish my task.

[@DougHExcel]

Hi Ayuning Karimah, glad you liked it, thanks for commenting!

[@ayuningkarimah5883]

Hi Doug H, don't mention it. 😃

[@imShifa]

Thank you, Sir.

[@DougHExcel]

You're Welcome!

[@taboakos]

God bless you Doug!! You saved my life! lol Thanks a bunch! Blessings!

[@DougHExcel]

Glad it helped, thanks for the comment!

[@jiayingwu7156]

saved my bm ia, thank you so much!!

[@DougHExcel]

You’re welcome!

[@banb6385]

Huge thx great video

[@DougHExcel]

Thx!

[@muthukumarneelakantan3276]

Thanks for the video

[@wangwenjing4034]

it's really helped a lot! thank you!!!

[@DougHExcel]

Thanks Wang Wenjing, glad it helped!

[@Spifly5]

thank you, helped me so much !!!!!!

[@DougHExcel]

Glad to have helped!

[@abrahamkisiwaga9229]

Thanks Doug H its helpfull

[@RayaTigerHotter]

AHH THANK YOU SO SO MUCH

[@DougHExcel]

Hi Raya Tiger Hotter, you're welcome!

[@EkanshiMandre]

Thanks sir ❤

[@DougHExcel]

Most welcome!

[@mohammadakmalludinbinmohdr8133]

thank you so much.. you help us :)

[@DougHExcel]

You're Welcome!

[@sasakiumiquema9608]

You saved me from dying in my marketing subject. THANK YOU

[@DougHExcel]

Hi Sasaki Umiquema...you're welcome, glad you liked!

[@tildahmagoba6954]

thank you soo very much for this video. it helped me understand break-even analysis a great deal

[@DougHExcel]

Hi Tildah Magoba, glad you liked it, thanks for commenting!

[@excelisfun]

Thanks!

[@sharkablake3631]

hi thanks soo much for this video it worked wonders with my assignment.

[@DougHExcel]

You're Welcome!

[@MrSayon20]

this is an amazing video! really helpful

[@DougHExcel]

Thanks Sayon Mukherjee, glad it helped!

[@alexmark1982]

You're awesome, thanks!

[@DougHExcel]

You're welcome, glad you liked!

[@ifydazzle]

wow!thank you

[@DougHExcel]

Hi Ify Dazzle, you're welcome!

[@prasadchavan1955]

Learnt fixed reference to cell. I'm wondering if I have total sell and variable cost in terms of amount and not in terms of units sold, how can create the breakeven? Basically I've restaurant business and Items I sell are large in number and have different price for each item.

[@DougHExcel]

Seems like another table is needed to aggregate the items to a pivot (ruclips.net/video/ZQxgYtl33xY/видео.html) so it can be put into the break even table for the chart.

[@mohamadamirulakram7616]

Thank you. Very helpful :-)

[@DougHExcel]

Thanks amierul akram, glad it helped!

[@mostafaabdelbakielsayed823]

Thank you so much

[@DougHExcel]

You're Welcome!

[@marketimage5487]

Thank you very much for making such a good video and explanation :-)

[@css_pakistan]

Mash Allah . Thank you brother for making such a good video and such good lecture. I ll subscribe for more videos by you.

[@DougHExcel]

Thanks for the comment, glad you liked!

[@megumiyamashita9270]

I can understand this explanation better than what I learn in class. duh. immediately I can undrstand

[@DougHExcel]

Thanks Deborah M., glad it helped!

[@stephenphan2761]

At 11:44 we can face a situation that when we change fixed cost the note is not dynamic change as we expected. I have met this issue in my practice.
Solution is to insert a text box as Doug H 's guidance and then type a reference cells directly on Excel Formula Bar. Good luck

[@DougHExcel]

Hi Stephen Phan, thanks for adding to the thread!

[@sanstk4131]

THANK YOU

[@DougHExcel]

You're Welcome!

[@paulinaferrero5477]

Super video, very helpful!! thank you so much :)))

[@DougHExcel]

Glad you liked!

[@zhuoqinghan6272]

This video is fking awesome!!!!!I like it.

[@DougHExcel]

Hi Zhuoqing Han, glad you liked it, thanks for commenting!

[@kaushif12]

My thanks good friend

[@DougHExcel]

You're welcome!

[@AkramAkram-wb1jo]

thank you

[@47elvy]

¡Fantastic!

[@DougHExcel]

Hi elvystat, thanks for the comment!

[@rickcarver212]

Can this be used to calculate the breakeven percent of overtime vs adding additional headcount?

[@DougHExcel]

don't see why not, but you'd need to figure out the how you'd want to put this together.

[@senjamsd4003]

Thank you very much for this important important tutorial.
I would like to request you to kindly share another tutorial where multiple products are involved and calculation of the break even.
Thanking you in advance,
Senjam Shantirani

[@DougHExcel]

Senjam S D, that is very interesting...thanks for letting me know.

[@leebatty5479]

Great info about break even, but I came to the video for formatting help and was disappointed when the chart was not formatted at all to what shows on link to the video. Misleading.

[@DougHExcel]

Hi Lee Batty, thanks for the feedback!

[@melynimason4216]

THANK YOUUUU

[@knowledgecentre2907]

sir,
you please make chart on ABC analysis.

[@DougHExcel]

Will try!

[@knowledgecentre2907]

@@DougHExcel thanks.

[@kushagragarg6973]

HOLY COW! This is what I wanted
Thanks, man you saved my ass

[@DougHExcel]

Glad it helped. Thanks for the comment!

[@October-zw4ed]

Thanks

[@DougHExcel]

You're Welcome!

[@exalism]

Super!

[@DougHExcel]

Glad you liked it!

[@nyallbarfoot3819]

When I click ctrl to highlight the columns needed for the graph it doesn't highlight them properly?

[@DougHExcel]

Sorry, don’t understand the comment/ question...

[@nyallbarfoot3819]

@@DougHExcel At the time I wasn't sure what the problem was but I managed to work it out in the end and I passed the module, the video helped massively

[@jenicareyes3056]

Do you have a tenplate for this? can i have it pls?

[@DougHExcel]

don't have template...sorry :-(

[@jenicareyes3056]

+Doug H it is ok. great video though 😊

[@sharonnekoye1122]

Hi, that really helped me, thanks alot

[@Zerodolfin]

Thank you so much! This tutorial helped me on a marketing project.

[@DougHExcel]

Thanks Christine Ritenour, glad it helped!

[@jesykrismoniyanti2086]

Thankyou

[@DougHExcel]

You're Welcome!

[@adamrules01]

My table doesnt work. it comes up with around 20 different series, not named or anything, and it doesn't let me put any numbers into it.

[@rattananihao]

go to insert, Scatter, and select the photo showing two lines crossing each other

[@tatoleon3217]

You have to press the cmnd button after selecting the whole unit column, not before.