Histogram bins driving me crazy-please HELP

[Emily]

Hi,

I'm trying to do a simple histogram but Excel seems to ignore the bins I
have set up. I have data ranging from 0 through 8. I have bins 0 through 8.
Yet when I enter this into the Histogram window, it gives me an output like
this:
Bin Frequency
0 1
1.142857143 21
2.285714286 7
3.428571429 5
4.571428571 7
5.714285714 6
6.857142857 1
More 10

First, what's with the decimals? And why "More" instead of "7" and "8"?

Thanks everyone! I'm losing my mind here!

 

[Joel]

Format the cells with your original data to show all the decimal places. The
format is probably number with0 decimal places. change to 10 decimal places.
the problem is with the data you are using.

 

[Emily]

Thanks Joel--I tried your suggestion but unfortunately it didn't make any
difference. Any other ideas? Thanks.

 

[Joel]

Format the output cells in General format. these are the cells that are
giving you the decimal point numbers.

 

[Emily]

Tried that, but they were already in General format. No change.

 

[Joel]

I can't tell what the problem is! I would start from scratch in a new
workbook. file a group of cells (D1:F10) with the numbers ) to 8. Then put
the numbers 0 to 8 in the cells A1 to A9.

Next go to menu tools - Data Analysis - Histogram. Open the boxes in pop up
windows for Input Range (D1:F10) Bin Range (A1:A9) and output Range (B1:B9).
See if this works.

If it works then go back to your original workbook and do the same thing
using the cells in your workbook. I suspect the one of the other boxes in
the Histogram Popup window was selected when you set up your original
histogram.