How to Make a Histogram in Microsoft Excel

Microsoft Excel has the functionality needed for financial, accounting, and statistical functions. Enter any amount of data and Microsoft Excel formulas can quickly generate analysis about the data. In addition, for presentation purposes, Microsoft Excel can generate a pie chart, bar chart, or histogram, just to name a few. A histogram provides a visual representation of the frequency of data. For example, during what hours of the day do most accidents happen on the expressway? A Microsoft Excel histogram can help answer this question. Learn how to create a histogram in Microsoft Excel.

Step

Open Microsoft Excel and go to "Tools", "Add-ins". Place a check in the box beside "Analysis ToolPak", click OK.

...

Step

Create a table with the following columns: Time of Day, Accidents, & Range. Enter the data in the following image.

Step

Go to "Tools", "Data Analysis" or "Data", "Data Analysis". Click on "Histogram" then click OK.

Step

Click the box beside "Input Range" and highlight the "Accidents" data. Click the box beside "Bin Range" and highlight the "Range" data. The Input Range is the raw data while the Bin Range provides the intervals to separate the data into.

...

Step

In the "Output Options" select "Output Range". Select an empty cell within the worksheet then press OK. This places the histogram and corresponding table on the same worksheet as the original information.

...

Step

According to the histogram, the most accidents occur at five hours during the day; when referring to the data table, those hours are 1am, 4am, 2pm (1400 hours), 5pm (1700 hours), and 11pm (2300 hours).