Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you enter input range for a histogram
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you enter input range for a histogram | Excel Discussion (Misc queries) | |||
Combo Box input range automatic update | Excel Discussion (Misc queries) | |||
How to enter data in maximum of one cell in range? | Excel Worksheet Functions | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Variable Input Range for Combo Box | Excel Worksheet Functions |