Make an interactive distribution curve (bell curve) in Excel - Easy Trick 💡

Excel Bell curves or frequency distribution curves are handy for analysing and understanding distribution of your data. Recently, someone asked me to make a bell-curve to visualize salary distribution of staff. While you can use formulas or complex techniques to make these, I used a simple trick to make the bell curve and add interactive effect to it. Needless to say, my clients were impressed.
Let me show the method in this video and take it to next level.
Time stamps for the video:
====================
0:00 - The bell curve problem
0:36 - Making the bell curve with Excel
3:27 - Adding department as slicer
3:54 - Fixing the axis issues
4:48 - Taking the bell curve to next level (splitting it by gender)
5:42 - Closing remarks
Example file:
==========
chandoo.org/wp/wp-content/upl...
👉Checkout my online course on Advanced Excel & Data analysis
===================================================
💻📗💥 chandoo.org/wp/excel-school-p...
#Excel #BellCurve

[@Soulenergy31]

Beautiful!!

[@chandoo_]

Thanks Saul. :)

[@shreyanshdangi4366]

Thanks for this...i Made together with this video and highly satisfied because i made the second bell curve by myself.
satisfaction like here👇

[@shreyanshdangi4366]

New concept learned++

[@rahulsadasivan512]

Thank you so much Mr. Chandoo!! I hope more people were kind-hearted like you!

[@chandoo_]

Aww.. so nice of you to say that.

[@erwincarlogonzales]

This is amazing! Thank you for your videos!

[@chandoo_]

Glad you like them!

[@meissamarpole2821]

This was so helpful! Exactly what I needed

[@chandoo_]

Awesome to hear that... 😀

[@papettipaolo]

amazing! thank you for sharing!

[@WhySoBroke]

Thanks for such amazing tips! Many blessings!

[@chandoo_]

You are so welcome!

[@xiomaragotch9453]

Thanks so much for sharing your knowledge in an easy way.

[@chandoo_]

Glad it was helpful!

[@wayneedmondson1065]

Hi Chandoo. Nice approach! Thanks for sharing these tips :)) Thumbs up!!

[@ns7647]

You are awesome brother, loved your content.

[@AccountingInstruction]

Great stuff. Thank you.

[@doulatram5550]

Thanks you so much for the great information sir .

[@shakilshaikh1325]

Superb explanation done

[@dilipshedge8503]

Excellent explanation thank you so much 💞

[@chandoo_]

You’re welcome 😊

[@monicaneira7601]

Great!!!

[@ganeshoptom]

You are the best. Awesome👍😊

[@chandoo_]

Thank you so much 😀

[@AdeKaryadi]

nice tutorial. good job. thanks

[@chandoo_]

You are welcome

[@olipeeeeee]

awesome. thx 🙏

[@chandoo_]

You're welcome 😊

[@excelworx8712]

great one, Chandoo

[@chandoo_]

Thank you.

[@KKB-tt4lj]

You should have 10,000,000 subscribers!

[@chandoo_]

😍

[@taizoondean689]

Thanks bro

[@chandoo_]

Welcome

[@datalab365]

Greetings from Data with Decision Channel. Good job!

[@chandoo_]

Greetings to you too :)

[@misnunalias2901]

thanks bro

[@chandoo_]

Welcome

[@prashantsharma26]

Hi Chandoo, as always something amazing to learn from you.
Just a query, Is there anyway we can also show some kind of Descriptive Statistics along with the chart.

[@dettito]

Great tutorial, Chandoo! I have a question - is there a way to restrict the smoothing curve to stay above the zero line?

[@robinmichaelchua601]

Thank you Bro! Quick Question: How do you do it if the data is an Employee Scorecard Rating of 1-5 and grouping is by 1?
I did it with this guide but it does not look like a bell curve.

[@JasonSmith-yz6nd]

Wonderful video. When I try to Group the numbers in column A, I get a message saying that I can not group that selection. Also, when I click on a cell to group it, it highlights the A cell and the B cell. I can not only highlight the A cell. I wonder if that is causing me to not be able to do the grouping. Unfortunately, I can not post a screenshot here. Do you have any suggestions as to what could be going on and how to fix it? Thanks

[@fermion4945]

Same problem

[@plavali_znaem]

very cool way around long workout with formulas! Only one question: how do I distribute the data that it's in a bell (gaussian) distribution? my data in fact is, but if i visualize the order it is now, I am getting two top mountain, which I want to avoid... Like, after the grouping at 2:07 your data happen to follow gaussian distribution just by itself, it seems so. How do I achieve that?

[@chandoo_]

You can adjust the group size or boundaries. But your data is in a different shape, that is what it is. You can't do much to change it.

[@Forest_Knight]

That's nice, easier than frequency arrays. Now the question is, why would the salary increase data be normally distributed? 🤨

[@chandoo_]

It can be.

[@SRCOMPUTEREDUCATION]

You are awesome sir ,I teach in college, I want to master Data Analysis of students, result analysis , and all such task, please suggest me path to master this task in Excel, I mean which topics in Excel should I master

[@chandoo_]

I suggest learning formulas, pivots and charts as a starting point. I am actually making a video on this very topic. Watch out for it.

[@SRCOMPUTEREDUCATION]

@@chandoo_ sir I watch everyone of your videos , excellent videos you are making

[@chandoo_]

Big thanks :)