Then you'll be ready to create a histogram. Make sure you load the Analysis ToolPak to add the Data Analysis command to the Data tab.

It uses two columns of data to create a histogram - one for data you want to analyze and one for bin numbers that represent the intervals by which you want to measure the frequency. To create a histogram in Excel, you use the Histogram tool of the Analysis ToolPak. A histogram or Pareto (sorted histogram) is a column chart that shows frequency data.