How to Create a Histogram in Excel:

1.Open Microsoft Excel.

2.Go to the OFFICE BUTTON ---->excel options----->Add-Ins---->Analysis Toolpak---->Go

3.Enter data that you want to be in a histogram.e.g.grades in one row and bin value in another row(Bin value is the range)

4.Click the data tab -----> select Data Analysis---->Histogram---->OK

5.Select the input range (this is your data) then select the bin range.

6.Check the chart output box.

7.Click OK.

8.Your histogram is ready

Source- www.wikihow.com