Microsoft KB Archive/214269

= How to use the Histogram add-in in Excel =

Article ID: 214269

Article Last Modified on 1/24/2007

-

APPLIES TO


 * Microsoft Office Excel 2007
 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition
 * Microsoft Excel 97 Standard Edition
 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q214269





For a Microsoft Excel 98 version of this article, see 189519.

IN THIS TASK

 * SUMMARY
 * Verify Installation of the Analysis ToolPak
 * Create a Histogram
 * REFERENCES



SUMMARY
This step-by-step article describes how to create a histogram with a chart from a sample set of data. The Analysis ToolPak that is included with Microsoft Excel includes a Histogram tool.

back to the top

Verify Installation of the Analysis ToolPak
Before you use the Histogram tool, you need to make sure the Analysis ToolPak Add-in is installed. To verify whether the Analysis ToolPak is installed, follow these steps:  In Microsoft Office Excel 2003 and in earlier versions of Excel, click Add-Ins on the Tools menu.

In Microsoft Office Excel 2007, follow these steps:  Click the Microsoft Office Button, and then click Excel Options. Click the Add-Ins category. In the Manage list, select Excel Add-ins, and then click Go.  In the Add-Ins dialog box, make sure that the Analysis ToolPak check box under Add-Ins available is selected. Click OK.</li></ol>

NOTE: In order for the Analysis ToolPak to be shown in the Add-Ins dialog box, it must be installed on your computer. If you do not see Analysis ToolPak in the Add-Ins dialog box, run Microsoft Excel Setup and add this component to the list of installed items.

back to the top

Create a Histogram
  Type the following in a new worksheet: <pre class="fixed_text">   A1:  87      B1: 20 A2: 27      B2: 40 A3: 45      B3: 60 A4: 62      B4: 80 A5:  3      B5: A6: 52      B6: A7: 20      B7: A8: 43      B8: A9: 74      B9: A10: 61     B10: </li> In Excel 2003 and in earlier versions of Excel, click Data Analysis on the Tools menu.

In Excel 2007, click Data Analysis in the Analysis group on the the Data tab.</li> In the Data Analysis dialog box, click Histogram, and then click OK.</li> In the Input Range box, type A1:A10.</li> In the Bin Range box, type B1:B4.</li> Under Output Options, click New Workbook, select the Chart Output check box, and then click OK.</li></ol>

A new workbook with a Histogram table and an embedded chart is generated.

Based on the sample data from step 1, the Histogram table will look like the following table:

<pre class="fixed_text">  A1: Bin     B1: Frequency A2: 20     B2:        2 A3: 40     B3:        1 A4: 60     B4:        3 A5: 80     B5:        3 A6: More   B6:        1 And, your chart will be a column chart that reflects the data in this Histogram table.

Excel counts the number of data points in each data bin. A data point is included in a particular data bin if the number is greater than the lowest bound and equal to or less than the greater bound for the data bin. In the example here, the bin that corresponds to data values from 0 to 20 contains two data points, 3 and 20.

If you omit the bin range, Excel creates a set of evenly distributed bins between the data's minimum and maximum values.

NOTE: You will not be able to create the Histogram chart if you specify the options (Output range or New worksheet ply) that create the Histogram table in the same workbook as your data.

For more information, click the following article number to view the article in the Microsoft Knowledge Base:

214029 Using Data Analysis tools on grouped sheets

back to the top

Additional query words: ATP Tool Pack Toolpack histo

Keywords: kbfunctions kbfuncstat kbaddin kbhowtomaster KB214269

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.