Histogram Creator

The Histogram Creator add-in for Microsoft Excel makes creating presentation quality histograms easy.

The Histogram Creator is totally menu-driven and fast. It gives you full control of the bin size and step size for great-looking output as illustrated by the following graph:

The Histogram Creator comes with a help and exercise file that lets you learn quickly and easily how to use the Histogram Creator's features.

In addition to creating histograms like the one above, the Histogram Creator can create area and column histograms. It also creates cumulative frequency tables. Another feature allows you to type in any value and see what percentage of the data points are less than the value and what percent is greater. The Histogram Creator easily handles error values in the data.

The Histogram Creator can not only create single histograms at a time, but also create multiple histograms automatically. You have the option of specifying the minimum and maximum values for the range covered by the bins and either the bin step size or the number of bins. Values outside the minimum and maximum range are captured in the additional bins that are automatically added. One of the features that assists in this process creates an initial table of the values so that you can easily modify the minimums, maximums, and bin size if necessary.

Other features of the Histogram Creator allow you to:

The first option is extremely useful if most of your data values are zero, and you are trying to get the distribution of the non-zero values. The second allows you to easily exclude fliers.