How to Make a Histogram in Microsoft Excel

1. Open Microsoft Excel and go to 'Tools', 'Add-ins'. Place a check in the box beside 'Analysis ToolPak', click OK.
2.
Create a table with the following columns: Time of Day, Accidents, Range. Enter the data in the following image.
3. Go to 'Tools', 'Data Analysis' or 'Data', 'Data Analysis'. Click on 'Histogram' then click OK.
4. 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.
5.
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.
6.
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).