Sheet: 
(2, 0)		-
(3, 0)		&Histogram
(3, 1)		histomacro
(3, 3)		Create a Histogram
(6, 1)		get range of values
(7, 1)		end if Cancel
(8, 1)		get range of distribution intervals
(9, 1)		end if Cancel
(10, 1)		position to first row
(11, 1)		position to output range
(14, 1)		for loop
(15, 1)		enter formula
(16, 1)		next row
(18, 1)		add over upper limit
(20, 1)		select the output
(21, 1)		convert to values from formulas
(23, 1)		cancel copy
(24, 1)		end
(27, 0)		I have just read your December 31, 1991 issue and found the histogram macro
(27, 1)		David Paradi
(28, 0)		for Excel to be very interesting.  Having used Lotus to create histograms, I
(28, 1)		Compuserve: 72461,1306
(29, 0)		thought that perhaps duplicating the way Lotus handles Data Distribution may
(29, 1)		6155 Fullerton Cres.
(30, 0)		help those who are more familiar with that interface.  I used your ideas and
(30, 1)		Mississuaga, ON
(31, 0)		wrote the macro HISTO.XLM, which, when run, adds a Histogram command to the
(31, 1)		CANADA   L5N 3A3
(32, 0)		Data Menu in Excel.  When you use the new command, it prompts you to select
(32, 1)		Phone: 416-824-1550
(33, 0)		the input range and the distribution range.  It then inserts all the correct
(34, 0)		array formulas and converts them to numbers as you did in your macro.  The
(35, 0)		ability to choose a distribution range is valuable when you want to use
(36, 0)		unevenly spaced intervals and/or they are not placed in the column next to
(37, 0)		your data.  The only item that does not show in this printout is that the name "histomacro"
(38, 0)		is defined as $a$7:$b$24 (this defines where the macro is located).