How to Create Bins in Excel 2007

Written by ashley leonard
  • Share
  • Tweet
  • Share
  • Email

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:


    Creating Bins in Excel 2007

  1. 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. 2

    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.

  3. 3

    Type your desired input range in the "Input Range" box.

  4. 4

    Type your desired range to create a new bin in the "Bin Range" box.

  5. 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.

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."

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.