"Make a Histogram - How to Create a Histogram with Microsoft 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 for test scores up to100 mark. Excel counts the number of occurrences in each bin.
When creating a histogram, you must provide three pieces of information:
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.
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.
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).
Click on Output Range: and select the cell where you want the results to start, or type the cell address (such as cell F2).
Pareto (sorted histogram) - sorts data from highest to lowest.
Cumulative Percentage - shows cumulative percentage.
Chart Output - check this to displays a chart in the worksheet.
Guide to Creating a Chart from Data in a Excel 2007 Worksheet
Recommended Books:Click on the image to view the details of the book.
The Ultimate Guide to
The Ultimate Guide to
Enjoy This Site?
Then why not use the button below, to add us to your favorite bookmarking service?
| Home | Excel 2007 Tutorials | Word 2007 Tutorials | PowerPoint 2007 Tutorials | Outlook 2007 Tutorials |
| Free Templates | Free Clip Arts | Free Tips & Tricks | Free Keyboard Shortcuts | Office 2003 Books |
| Excel 2003 Tutorials | Word 2003 Tutorials | PowerPoint 2003 Tutorials | Outlook 2003 Tutorials |
| Office 2010 Tutorials | Excel 2010 Tutorials | Word 2010 Tutorials | PowerPoint 2010 Tutorials |