Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
bin
How do you select Bin values when using the Histogran?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
bin
Hi,
You don't have to specify the Bin values for the HISTOGRAM function. If you omit them, Excel will use an appropriate set of bins based on the minimum and maximum of your data. You can also make up a column of bin values of your choice (it should be IN ASCENDING ORDER). For example, if the minimum and maximum of your data are 0.48 and 9.52, you could create bin values 0.0, 1.0, 2.0, ...... 10.0 (or something like that). Then, you have to specify the bin range in the HISTOGRAM function. Regards, B. R. Ramachandran "Knowledge001" wrote: How do you select Bin values when using the Histogran? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|