Create presentation quality Excel histograms

Histogram Creator in detail

The Histogram Creator for Excel makes creating presentation quality histograms easy. It comes with an exercise file that lets you learn quickly and easily how to use the Histogram Creator's features. The exercise file can be easily opened from the About menu or from the main Histogram Creator menu.

The Histogram Creator gives you full control of the bin size and step size for great looking output, as illustrated by the following graph:

To see a sample of a full report, view this report in PDF format.

In addition to creating histograms like the above, the Histogram Creator creates cumulative frequency tables. And, it is totally menu drive and very fast. Another feature allows you to type in any value and see what percent of the data points is 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 from a range of data, it can 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 assist in this process creates an initial table of the values so that you can easily modify if necessary. The menu that gives you these features has the following appearance:

Another feature of the Histogram Creator allows you to:

• Exclude data points that are less than or equal to a given value.
• Or exclude data points that are greater than a given value.

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.

The Histogram Creator comes with an exercise file and sample data. The exercise file has sample exercise that show you how to use each of the features in the above dialog.

See also in "Excel - Chart creation and management"

• Cascade Chart Creator - Create Cascade Charts in Excel.
• Chart Assistant - Easily create hundreds of Excel charts.
• Chart Labeler - Easily label and re-arrange your Excel chart points.
• Chart Viewer - A full screen Excel charts slide show.
• Quick Chart Creator - Use one Excel chart for many rows of data.
• Waterfall Chart Creator - Create Excel waterfall charts easily.