|
Topic 32: Guide to creating Histogram with Excel 2007 |
Views: 2441
|
Thread Tools | Rate Thread |
#1
|
|||
|
|||
Topic 32: Guide to creating Histogram with Excel 2007
With Excel 2007, you can make a histogram to group a list of values into categories and compare the categories. Excel calls these categories bins.
To better illustrate on how to create a histogram, create a worksheet as below: This worksheet is to display the test scores for a group of students, for example, your first bin might be <=50, representing scores of 50 mark or under; your second bin might be 75; and last bin fortest scores up to100 mark. Excel counts the number of occurrences in each bin. Similar Threads:
|
#2
|
|||
|
|||
When creating a histogram, you must provide three pieces of information:
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. Note: The histogram tool is part of the Analysis Toolpak, which you may need to install the add-ins first as explain in the Excel 2007 add-in article. |
#3
|
|||
|
|||
To create or make a histogram
|
#4
|
|||
|
|||
Click on Input Range:, then click and drag the range of numbers to categorize (cells B2 to B13 in our case).
Click on Bin Range:, then click and drag the range of bins (cells D6 to D9 in our case).
|