How to Make a Frequency Distribution Graph in Excel for Mac 2011. You can use the Frequency function within Excel in Microsoft Office 2011 for the Macintosh platform to calculate the frequency of ...