Re: Normal Distribution Graph
It's a histogram... You have to create bins to hold counts of data that falls within ranges in order to get a visual on whether or not the data approximates a normal distribution.
Search for the "distributions" example in the download section of my web site.
The histogram feature of the analysis toolpack (don't get me wrong I use xNPV & xIRR all the time) does us a disservice by not generating the formulas necessary to evaluate the data range to create the bins. I don't recommend it.
Sub All_Macros(Optional control As Variant)