Microsoft Excel 2007 is an application used to create spreadsheets, charts and tables. Excel 2007 is frequently used for business meetings and school presentations. Bins are part of Excel 2007's graphic options. A bin is a range placed in a workbook or histogram. The bin range is based on your specific project. Creating bins should help the user stay organised and improve his productivity and presentations.
- Skill level:
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.
Click "Data Analysis," located in the analysis group on the data tab. In the dialogue box after clicking data analysis, click "Histogram" and then click OK.
Type your desired input range in the "Input Range" box.
Type your desired range to create a new bin in the "Bin Range" box.
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.
Creating Bins in Excel 2007
Tips and warnings
- If you don't see the "Data Analysis" button in the group on the data tab, you must load the Analysis ToolPak add-in. To install the Analysis ToolPak add-in, click "Tools" then select "Add-Ins."
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for