What are Histograms in Excel?

A histogram is a column chart that shows the frequency of data in a certain range in a simpler way. It provides the visualization of numerical data by using the number of data points that fall within a specified range of values (also called “bins”). Steps to create a histogram are:

  1. Make sure you load the Analysis ToolPakto add the Data Analysis command to the Data tab.
  2. On a worksheet, type the input data in one column, and the bin numbers in ascending order in another column.
  3. Click Data > Data Analysis > Histogram > OK.