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
