Microsoft Office Tutorials and References
In Depth Information
With Excel, you can use histograms to group a list of
values into categories and compare the categories.
Excel calls these categories bins. To display the test
scores for a group of students, for example, your
first bin might be <=60, representing scores of 60
percent or under; your second bin might be 70; and
so on up to a bin for test scores over 100 percent.
Excel counts the number of occurrences in each bin.
When creating a histogram, you must provide three
pieces of information. First, define the raw data you
want to sort. Then define the bins. Finally, specify
the cell in which you want the result to appear. Your
bins must be in lowest to highest order. The results
can appear in the current worksheet, in a new
worksheet, or in a new workbook. As you make
changes to your data, Excel does not automatically
make changes to your histogram. You must
regenerate your histogram when you make changes
to your data.
The histogram tool is part of the Analysis Toolpak,
which you may need to install as explained in
Type the values that define
Note: The bins must be ordered
from lowest to highest but need
not be the same size.
Click the Data tab.
Click Data Analysis in the
l The Data Analysis dialog box