Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I was creating a histogram; now i have data but no histogram. | Excel Worksheet Functions | |||
How to Histogram w/o raw data but histogram Table on Excel | Charts and Charting in Excel | |||
Histogram pt 2 | Charts and Charting in Excel | |||
Histograms: how change number of bins | Excel Discussion (Misc queries) | |||
If I have X,Y data how do I sum the Y values using a set of bins based on x values | Excel Worksheet Functions |