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.exceltraining101.com/p/tr...
📚 Excel Books & Tech Gear ➜ www.amazon.com/shop/dough
⚙️ Tools: Screencasting ➜ techsmith.z6rjha.net/5Qe53
⚙️ Tools: Microsoft Office ➜ microsoft.msafflnk.net/rKL0G
⚙️ Tools: TubeBuddy ➜ www.tubebuddy.com/et101
📝 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.buymeacoffee.com/dough
#excel
#msexcel
#doughexcel
~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
• Convert Table in a PDF...
~-~~-~~~-~~-~

[@kathleenmcdaid6960]

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

[@ErickaMusa]

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

[@benorchard6583]

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

[@ishraqiqbal4291]

It's an amazing video. Clearly explained!! Good job Doug... Appreciate 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...

[@crysellasmith7714]

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

[@pepperjohnson2659]

Very easy to understand and follow...thank you

[@zafarshamsi2377]

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

[@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!

[@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!

[@ComfortAgyekum]

clearer and better than what I knew before.

[@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!

[@Everyday-AJ]

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

[@sfox3255]

Simple and easy to follow. Thanks Doug.

[@DougHExcel]

You're welcome, thanks for the comment!

[@littlejack223]

thanks a lot man! thanks for taking step by step

[@ivanabunjevacki4935]

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

[@DougHExcel]

Hi Ivana Bunjevacki, thanks for the kind words!

[@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!

[@excelisfun]

Thanks!

[@chrismckenna8379]

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

[@DougHExcel]

Thanks for the kind words!

[@bbbbbb3186]

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

[@DougHExcel]

You're welcome!

[@aahizam828]

YOU'RE A LIFE SAVER THANKS

[@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!

[@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!

[@MrJazAfonso]

Great presentation,
Very useful video,
Thank you

[@joetheseventeenth]

Thanks man. Very simple and straight forward.

[@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!

[@muthukumarneelakantan3276]

Thanks for the video

[@shanoguyo3786]

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

[@DougHExcel]

Thanks for the kind words!

[@nikossalavrakos6476]

Good work and very enlightening, thank you

[@DougHExcel]

Thanks for your kind words!

[@ndhulkhogan]

This was excellent! Thank-you!

[@DougHExcel]

Glad you enjoyed it!

[@marketimage5487]

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

[@bushrawalji9461]

Excellent Video! Very helpful..Thank you!

[@DougHExcel]

Hi Bushra Walji, thanks for the comment!

[@josher3436]

Great video. Logical and informative. Thanks

[@DougHExcel]

You're welcome!

[@abrahamkisiwaga9229]

Thanks Doug H its helpfull

[@amako16]

Amazing video! Many thanks for your time and help!

[@DougHExcel]

Glad it helped!

[@ariel_ba]

Thank you so much for your time!

[@DougHExcel]

You're Welcome!

[@paulinaferrero5477]

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

[@DougHExcel]

Glad you liked!

[@mariomorenojr6229]

Enjoyed this, I learned new tips, Thanks

[@DougHExcel]

You're welcome!

[@bostaffarts]

Thank you very much for creating this sheet!

[@DougHExcel]

You're Welcome!

[@shubhamshetshirodkar895]

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

[@DougHExcel]

Glad you liked

[@vincentgan7249]

Thank you. You're my hero!

[@DougHExcel]

Hi vincent jetz, thanks for the kind words!

[@MrSayon20]

this is an amazing video! really helpful

[@DougHExcel]

Thanks Sayon Mukherjee, glad it helped!

[@girishghadge8460]

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

[@DougHExcel]

Thanks for the comment!

[@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!

[@wangwenjing4034]

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

[@DougHExcel]

Thanks Wang Wenjing, glad it helped!

[@lisajames5881]

Very Helpful!!!!!

[@DougHExcel]

Thanks Lisa James, glad it helped!

[@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!

[@d_i_k_s_h_a5017]

Its really helpful. Thank you soo much.

[@DougHExcel]

You're welcome!

[@SaltFactoryForeman]

This helped me a lot, thanks.

[@DougHExcel]

You're welcome!

[@lynetteklish3160]

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

[@DougHExcel]

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

[@alyssali6690]

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

[@DougHExcel]

Glad it helped!

[@Spifly5]

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

[@DougHExcel]

Glad to have helped!

[@sharkablake3631]

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

[@DougHExcel]

You're Welcome!

[@alexmark1982]

You're awesome, thanks!

[@DougHExcel]

You're welcome, glad you liked!

[@elizangelahall2246]

Thanks Doug!

[@DougHExcel]

You are welcome!

[@manishbirdi]

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

[@DougHExcel]

Glad it helped!

[@DougHExcel]

You're welcome!

[@sebus212pl4]

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

[@DougHExcel]

You’re welcome!

[@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!

[@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!

[@banb6385]

Huge thx great video

[@DougHExcel]

Thx!

[@abduhamdan]

It's actually sufficient for everyone to understand

[@DougHExcel]

Hi abdu hamdan, thanks for the comment!

[@mohamadamirulakram7616]

Thank you. Very helpful :-)

[@DougHExcel]

Thanks amierul akram, glad it helped!

[@imShifa]

Thank you, Sir.

[@DougHExcel]

You're Welcome!

[@mostafaabdelbakielsayed823]

Thank you so much

[@DougHExcel]

You're Welcome!

[@mohammadakmalludinbinmohdr8133]

thank you so much.. you help us :)

[@DougHExcel]

You're Welcome!

[@alexclarke3078]

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

[@DougHExcel]

Fantastic!

[@ifydazzle]

wow!thank you

[@DougHExcel]

Hi Ify Dazzle, you're welcome!

[@tallieet2]

Great Explanation. Thanks Doug.
How does this application apply to monthly and/or annual sales data rather than an individual inventory item?

[@user-nn2ns9ur6y]

AHH THANK YOU SO SO MUCH

[@DougHExcel]

Hi Raya Tiger Hotter, you're welcome!

[@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.

[@jiayingwu7156]

saved my bm ia, thank you so much!!

[@DougHExcel]

You’re welcome!

[@AkramAkram-wb1jo]

thank you

[@sanstk4131]

THANK YOU

[@DougHExcel]

You're Welcome!

[@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. 😃

[@vckarabia]

very nice explain

[@DougHExcel]

Hi mugavai Nanban, thanks for the comment!

[@sharonnekoye1122]

Hi, that really helped me, thanks alot

[@melynimason4216]

THANK YOUUUU

[@sawadheelad9193]

Nice.. You're my hero 😁

[@DougHExcel]

Hi Sawadheel Ad, thanks for the kind words!

[@Zerodolfin]

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

[@DougHExcel]

Thanks Christine Ritenour, glad it helped!

[@sasakiumiquema9608]

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

[@DougHExcel]

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

[@user-cr6cg7zk1q]

Thanks sir ❤

[@DougHExcel]

Most welcome!

[@kaushif12]

My thanks good friend

[@DougHExcel]

You're welcome!

[@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!

[@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!

[@zhuoqinghan6272]

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

[@DougHExcel]

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

[@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!

[@47elvy]

¡Fantastic!

[@DougHExcel]

Hi elvystat, thanks for the comment!

[@exalism]

Super!

[@DougHExcel]

Glad you liked it!

[@jesykrismoniyanti2086]

Thankyou

[@DougHExcel]

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 (czcams.com/video/ZQxgYtl33xY/video.html) so it can be put into the break even table for the chart.

[@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.

[@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!

[@arshadinaumaranajib3840]

im stuck.....when i select the line chart....im asked place where i want sparklines to be placed....what is it and how do i get past this

[@DougHExcel]

Hi Arshadina Najib, thanks for the comment! that is odd, cause sparkline are in cell, not part of the chart object.

[@Toolmamon]

I can't get the graph to look like yours. I am doing the exact same thing

[@CheriBenIesau]

+Jaime Venegas Different version of Excel, maybe. I had a similar issue and that was, well, the issue. Good luck.

[@l8870]

nice

[@DougHExcel]

Thanks

[@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.

[@nafisaalam2409]

Hmm nice video and well explained.But why do i get 20 different series i don get it,i even have the excel model as yours with the same year.Can anyone help me?

[@bushrawalji9461]

+Nafisa Alam I had the same at first ..what you do is first click the Unit down arrow then click CRTL and the rest of the columns not CRTL first, only after you have selected the Unit column first..hope it works.

[@nafisaalam2409]

i got it fixed by my husband,thanks for your help though its just that i posted it 3 month s ago LOL

[@hywong1546]

+Nafisa Alam I have the same problem as yours but I have no clue how to fix it, may I ask how do you fix it? thanks

[@nafisaalam2409]

I wish i could help you but i dont know it myself, my husband fixed it in 30 secs and i didt even look at where he was cleaning.

[@xChelleaux]

Aha this worked! Thank you so much! :)