How do you enter input range for a histogram
Assume your data values are between 1 to 100 in range A1 to A500 and you want
a histogram showing ranges in blocks of of 10 i.e. 1-10, 11-20, etc
Create a column (say B) with values 10,20,30 up to 100; this is your "bin"
range which you select in the "Histogram" form.
Input Range: A1:A500
Bin Range: B1:B10
HTH
"Irishrose28" wrote:
I am trying to create a histogram and each time I begin to proceed a screen
pops up that asks me to entere the input range and bin range. I have tried
to do this a numebr of times and I have not been successful. This is the
first time I am trying to create the histogram so I am not sure how to enter
this information.
|