Article ID: 189519 - View products that this article applies to.
This article was previously published under Q189519
This article has been archived. It is offered "as is" and will no longer be updated.
The Analysis ToolPak that ships with Microsoft Excel includes a Histogram tool. This article describes how to create a histogram with a chart from a sample set of data.
Installing the Analysis ToolPakBefore using the Histogram tool, you need to make sure the Analysis ToolPak Add-in is loaded. To verify whether the Analysis ToolPak is loaded, follow these steps:
Creating a Histogram
and your chart will be a column chart reflecting the data in this Histogram table.
A1: Bin B1: Frequency A2: 20 B2: 2 A3: 40 B3: 1 A4: 60 B4: 3 A5: 80 B5: 3 A6: More B6: 1
Microsoft 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, Microsoft 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 additional information, please see the following article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/183188/EN-US/ )XL98: ATP Error: "Cannot Add Chart to a Shared Workbook"
For more information about the Histogram tool, click the Office Assistant, type "histogram," click Search, and then click to view "Histogram analysis tool."
NOTE: If the Assistant is hidden, click the Office Assistant button on the Standard toolbar. If Microsoft Help is not installed on your computer, please see the following article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/179216/EN-US/ )OFF98: How to Use the Microsoft Office Installer Program
Article ID: 189519 - Last Review: October 9, 2013 - Revision: 1.0