Excel Dynamic Chart #11: Dynamic Area Chart with IF Function - Normal Distribution Chart Statistics

Download Excel Start File: people.highlin...
Download Excel Finished File: people.highlin...
See how to use the IF function in a column to create a dynamic range for an area chart. Statistics Normal Distribution Area Chart with X values.
Standard Normal Distribution Area Chart Probability Theory Statistics.

[@excelisfun]

I have no idea, but I am pretty sure that it can be done with VBA code. This site is the BEST for asking Excel questions: mrexcel[dot]com/forum After you post to that site, send me the link (KZbin e-mail) so that I can learn too!

[@excelisfun]

You are welcome for the videos! Merry Christmas to you and your family!!

[@excelisfun]

You are welcome - I am glad that it helps!

[@excelisfun]

You are welcome!

[@nhoj277]

I use this trick with tastytrades option probabilities spreadsheets, they are password protected tastytrades, and their graph demos are just png files, i have their formulas from samir khans investexcel.net option probability calculator, although he describes them in a slightly confusing manner, the formulas were first published in a non excel format in Lawrence McMillans famous options book. You can have live expiration probabilities graphed as a normal curve with this video's techniques and the above formulas, thanks again mike you are too good man, keep on keeping on!!!

[@wayvalyons7464]

When I make this in Excel 2011 for Mac, the line that goes from the top of the curve to the x axis is slanted. Do you have any idea why that happens and how to fix it?

[@sergioereis]

Man, you saved me! Had not found how could to do it somewhere. Thanks!

[@krn14242]

Mike Merry Christmas to you and your family. Thanks for all the great videos. kevin

[@wjj4832]

I'm putting a lot of your help to work already and anxious to give this a shot! Thanks!

[@christopherdoukakis1208]

Thanks a lot!! Thanks to you now i have finally figured out how to generate a bell curve with the appropiate areas to illustrate the probabilities (i.e. in the form P(X

[@ClauPego]

I would love that too

[@christopherdoukakis1208]

never mind i figured it out!! was incorrectly using the IF function.

[@thepickle7047]

What if you want an area between two values

[@LMONDEGREEN]

You really helped me

[@Search4Knowledge]

Wonderful, thanks!