View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Emily Emily is offline
external usenet poster
 
Posts: 40
Default Histogram bins driving me crazy-please HELP

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!