You can also click within the box, hold the “Shift” key and click on the worksheet to select a range of cells.Įnter the range of cells you’re using for the bin numbers in the “Bin Range” box or click within the box, hold the “Shift” key and click on the worksheet to select a range of cells. Select “Histogram” in the “Analysis Tools” menu and click the “OK” button.Įnter the range of cells you’re using for the input data in the “Input Range” box. The second cell is 200 all numbers between 101 and 200 will be placed into that bin.Ĭlick the “Data” tab and click “Data Analysis” in the “Analysis” section. For example, if you want intervals of 100, the first cell of the bin number column should be 100 all numbers below 100 will be placed into this bin. These represent the intervals that the input data cells are to be placed within. These are the numbers to be analyzed by the histogram.Ĭreate a column of bin numbers.
