Excel template: Histogram builder with adjustable bin sizes

Excel template: Histogram builder with adjustable bin sizes

25 January 2016

If you work in consulting or some other profession that requires you to analyze data, sooner or later, you'll need to build a histogram. This is because the histogram is one of the most effective methods to visualize and understand a data set.

Conceptually, a histogram is fairly simple, but building a histogram is often a clunky process. This article describes a histogram builder template that makes the process easy. It includes adjustable bin sizes and a chart with dynamic ranges to automatically show only the selected number of bins.