ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Histogram bins being ignored (https://www.excelbanter.com/excel-discussion-misc-queries/194513-histogram-bins-being-ignored.html)

Emily

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