Use Excel functions to find and label the maximum value in the data set. Use Excel functions to find and label the minimum value in the data set. Use the Max and Min value to construct appropriate bins for the data.

(Remember, it's often to have 5~6 bins. One way to find the bins is to start by finding the range and dividing by 5 or 6. This will give you the bin width. Now, pick your lowest bin to be just a bit higher than your minimum value. Next, let your bins go up by the bid width that you calculated a moment before. Keep going until you reach a bin that is higher than your maximum data value. At this point, you have all of your bins.)

Use Excel (through Data Analysis in the Data Tab) to construct a frequency table for this data. Construct a Histogram for this Data. Use the Frequency information for the Legend Entries and use the bin values for the Horizontal Axis. Make sure the horizontal and vertical axes have labels (not the word bin) and that the bars touch.