![]() |
Histogram bins being ignored
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! |
All times are GMT +1. The time now is 03:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com