Making a histogram with the correct x-axis labels

1. First check that you have the Analysis ToolPak installed.
Tools > Add-Ins > Click on Analysis ToolPak

2. Then select Tools > Data Analysis > Histogram > OK
Enter the Input Range and the Bin Range (as you do with the Frequency function) > OK

3. This will put you in a new Sheet with Bin and Frequency data shown.
Select Chart Wizard > Clustered Column > Next > Finish

You should see a histogram with the correct x-axis labels.