View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default 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.