Block Histogram


A histogram is a graphical way of presenting a frequency distribution of quantitative data organised into a number equally spaced intervals or bins (e.g. 1-10, 11-20…). The interval range is selected to reduce the amount of information while still providing enough variability to picture the shape of the distribution.

The intervals are displayed on one axis (often the x-axis), against which are plotted the frequency of a particular piece of data which falls within that interval (often on the y-axis). Histograms can also be constructed by plotting relative frequencies, percentages, or proportions on the y-axis. Unlike the column chart, a histogram is only appropriate for variables whose values are numerical and measured on an interval scale. A histogram is essentially a column chart with no space between the columns (as would be the default in Excel).

Histograms generally make analysis of large data sets (>100 observations) easier due to the preparation required for a stem and leaf plots in a large dataset. They can begin to show the central tendency and dispersion of a data set and can also help detect any unusual observations (outliers) or gaps. However, the histogram’s utility is certainly not limited to large datasets.


Many Eyes example

In this Many Eyes example, the simple histogram is enhanced by the addition of the blocks to identify the breakdown of a third variable. Insightful in many ways, but be sure the extra dimension of data is needed to deliver the message.


Frequency Distribution of Height of 25 Students.


Advice for CHOOSING this option (tips and traps)

Histograms are really only used for continuous data grouped into intervals.

Only add additional elements if they assist in delivering the message of the visualisation.

Advice for USING this option (tips and traps)

How to group the data can be a challenge. Sometimes obvious groupings like 1-5, 6-10 and so on can improperly skew the data. In those cases, you may want to look for natural breaks in the raw data. For example, if there was a large gap in your raw data between 6 and 10, you might choose to divide at that gap. Using natural breaks can also be tricky, however, because rather than continuous groups like 1-6, 7-13 it would be irregular like 1-6, 10-14. So be sure to clearly label the beginning and end of each group.

Excel does not have a histogram chart option. See resources below on how to prepare a histogram in Excel.



Bar Charts and Histograms: Clear explanation on how to make histograms and bar charts (with a clear 9-minute video – you can flip through different chapters if you find it too long).

Graphing with Excel: Bar Graphs and Histograms: Step by step written instructions on creating a histogram in Excel

Creating a Histogram in Excel 2010: this 4:16 video shows how to create these graphs in Microsoft Excel

Other ways to compare sets of values

Bar Chart
Illustrating the main features of the distribution of a data set in a clear way.

Bubble Chart
Providing a way to communicate complicated data sets quickly and easily.

Bullet graph
Using a target line to show progress to date, often with levels of performance graphed in the background.​

Deviation bar graph
Aligning two bar graphs along their spine to compare the shape of their data sets.​

Dot plot
Plotting two or more dots on a single line for each category being compared.​

Small multiples
Positioning several small graphs with the same scale in a row for easy comparison.​


School of Psychology, University of New England (2000). Histograms and Bar charts. In: Chapter 4 Analysing the data (Research Options and Statistics course).

Easton, V. J., & McColl, J. H. (1997). Statistics Glossary

Updated: 31st October 2014 - 12:37pm
This Option is useful for:
A special thanks to this page's contributors
Banana hill.
United States of America.
Director of BetterEvaluation/ Professor of Public Sector Evaluation, Australia and New Zealand School of Government.


There are currently no comments. Be the first to comment on this page!

Add new comment

Login Login and comment as BetterEvaluation member or simply fill out the fields below.