Browse » Home
Sunday, December 16, 2012
How to Construct a Histogram in Microsoft Excel
1. Click on the 'Data' tab in Excel 2007 or the 'Tools' tab in Excel 2003.
2. Click on 'Data Analysis.'
3. Choose 'Histogram' from the list box, then press 'OK.'
4. Tell Excel where your data is by entering a range in the 'Input range' box. For example, if your data is in column A2 to A11, type 'A2:A11' into the box. If you have entered your own bin values (a range of data for the columns), enter the location of the data in the 'Bin values' box in the same format. For example, if your bins are located in B2 to B5, enter 'B2:B5' in the bin values box.
5. Check the 'Chart Output' box, then press 'OK.' Excel will insert a histogram into the spreadsheet.