Want to create a histogram in Excel? Learn how to do this in Excel 2016, 2013, 2010 & 2007 (using inbuilt chart, data analysis toolpack & Frequency formula)
Histograms are commonly used throughout statistics. Create a histogram by hand following a seven-step process.
Unlike a bar chart, the area of a bar in a histogram represents the frequency, not the height. The frequency is calculated by multiplying the width of the bin by the height. The height of a bar in a histogram indicates frequency (counts) only if the bin widths are evenly spaced.
This example teaches you how to make a histogram in Excel. 1. First, enter the bin numbers (upper levels) in the range C4:C8. 2. On the Data tab, in the Analysis group, click Data Analysis. Note: can't find the Data Analysis button? Click here to load the Analysis ToolPak add-in. 3. Select Histogram and click OK. 4. Select the range A2:A19. 5.