How to create different types of histogram charts in Excel

Excel 365
A histogram chart visualizes the distribution of continuous data. Each column in the histogram chart represents the frequency (amount) of the data within the specific range.

The main differences between a histogram chart and a regular column chart are:

  • a column (bar) graph describes two variables:
    • the horizontal axis shows the items and
    • the vertical axis shows their values,
  • a histogram describes only one variable:
    • the horizontal axis shows the value ranges,
    • the vertical axis shows the frequencies of values within the range.

Histograms help evaluate visually where values are concentrated, what are the extreme values, and the generic shape of the distribution of the values.

In the previous versions of Excel, to create a histogram chart, it was necessary to calculate frequencies of each item (interval) and create a column or a bar chart with two parameters: items and their frequencies. Excel 2016 offers several different ways to create histogram charts:

Comparative Histogram chart in Excel 2016

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information you’ve provided to them or they’ve collected from your use of their services.

Learn more