Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default 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   Report Post  
Posted to microsoft.public.excel.misc
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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do you enter input range for a histogram Irishrose28 Excel Discussion (Misc queries) 0 August 4th 06 02:21 PM
Combo Box input range automatic update John M Excel Discussion (Misc queries) 1 May 11th 06 08:05 PM
How to enter data in maximum of one cell in range? bobedcar Excel Worksheet Functions 0 March 22nd 06 09:56 AM
checking that cells have a value before the workbook will close kcdonaldson Excel Worksheet Functions 8 December 5th 05 04:57 PM
Variable Input Range for Combo Box Defoes Right Boot Excel Worksheet Functions 2 July 20th 05 03:44 PM


All times are GMT +1. The time now is 01:48 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"