Use Tools | Data Analysis | Histogram
If you do not see Data Analysis then you need to but the Office/Excel CD in
the drive and use Add/Delete Programs to install this feature.
OR
You could use the FREQUENCY function to make a data table then make a column
chart. You can format the data series in a column chart so that the columns
have no gaps between them
I searched Google with "Excel histogram" and found a number of sites. This
one seems helpful
http://www.treeplan.com/BetterHistogram_20041117_1555.htm
Please return if you need more details
best wishes