ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do you enter input range for a histogram (https://www.excelbanter.com/excel-discussion-misc-queries/103165-how-do-you-enter-input-range-histogram.html)

Irishrose28

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.

Toppers

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.



All times are GMT +1. The time now is 07:13 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com