Article ID: 214269 - View products that this article applies to.
This article was previously published under Q214269
For a Microsoft Excel 98 version of this article, see 189519
You can analyze your data and display it in a histogram (a column chart that displays frequency data) by using the Histogram tool of the Analysis ToolPak in Microsoft Office Excel. To create a histogram, you must organize the data in two columns on the worksheet. These columns must contain input data and bin numbers. Input data is the data that you want to analyze by using the Histogram tool. Bin numbers are the numbers that represent the intervals that you want the Histogram tool to use for measuring the input data in the data analysis.
When you use the Histogram tool, 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 largest bound for the data bin. If you omit the bin range, Excel creates a set of evenly distributed bins between the minimum and maximum values of the input data.
The output of the histogram analysis is displayed on a new worksheet (or in a new workbook) and shows a histogram table and a column chart that reflects the data in the histogram table.
Before you can use the Histogram tool, you have to make sure that the Analysis ToolPak Add-in is installed.
Make sure that the Analysis ToolPak Add-in is installedTo make sure that the Analysis ToolPak Add-in is installed, follow these steps:
Create a histogram tableTo create a histogram table, follow these steps:
Based on the sample data from step 1, the histogram table will resemble the following table:
Your chart will be a column chart that reflects the data in this histogram table. In this example, the bin that corresponds to data values from 0 to 20 contains two data points: 3 and 20.
A1: Bin B1: Frequency A2: 20 B2: 2 A3: 40 B3: 1 A4: 60 B4: 3 A5: 80 B5: 3 A6: More B6: 1
For more information, click the following article number to view the article in the Microsoft Knowledge Base:
(https://support.microsoft.com/kb/214029/ )Using Data Analysis tools on grouped sheets
Article ID: 214269 - Last Review: July 12, 2013 - Revision: 11.1