How to Create Bins in Excel 2007

Creating Bins in Excel 2007
1. Click the Microsoft Office link in your start box and click on Microsoft Excel 2007. Microsoft Excel 2007 is the green icon, located among the choices of Microsoft programs.
2. Click 'Data Analysis,' located in the analysis group on the data tab. In the dialog box after clicking data analysis, click 'Histogram' and then click OK.
3. Type your desired input range in the 'Input Range' box.
4. Type your desired range to create a new bin in the 'Bin Range' box.
5. Click 'New Workbook' which is located under 'Output Options.' Check the 'Chart Output' check box then click OK. Your new bin within the workbook is created.