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. From that calculation you can ...

The Gap Width option in Excel for Mac 2011 controls the spacing of bars in a column graph. Decreasing this percentage shrinks the empty space between columns by widening the columns themselves.