In the next column, type the bin numbers in ascending order, adding a label in the first cell if you want. The Histogram tool won't work with qualitative numeric data, like identification numbers entered as text. Be sure to use quantitative numeric data, like item amounts or test scores. On a worksheet, type the input data in one column, adding a label in the first cell if you want. 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.
