You can use the Frequency function within Excel in Microsoft Office 2011 for the Macintosh platform to calculate the frequency of data that lies within a certain range.

Before creating your histogram, import or input the data you want to display as a histogram in a new Excel workbook table with separate columns or rows for value and frequency data.