A frequency distribution is a representation, either in a graphical or tabular format, that counts how often a specific item happens.

What Is a Histogram? A histogram graphically represents data distribution, showing the frequency of numerical data within specified intervals.

Before creating your histogram, import or input the data you want to display as a histogram in a new Excel workbook table with separate columns or rows for value and frequency data.