histograms with unequal intervals

myrmica · Apr 30th, 2002, 05:05 AM

Can histograms with unequal intervals be made in Excel? If not can anyone write a macro to do it? I am a biology teacher interested in computers trying to advise a Maths department!

Damon Ostrander · Apr 30th, 2002, 10:49 AM

Hi Gary,

Yes, histograms can be done in Excel with unequal intervals, and does not necessarily require the use of macros. How one would do this would depend on how the intervals are specified, how one would want them labeled (assuming they are to be presented graphically), where the data come from, etc. Without more of this kind of information it is difficult to provide specific advice.

Damon

Jay Petrulis · Apr 30th, 2002, 11:43 AM

You may find that Jon Peltier's "Brickyard" chart example to be similar to what you'd want. Not exact, but you may be able to use the techniques.

http://www.geocities.com/jonpeltier/...Brickyard.html

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 30th, 2002, 05:05 AM	#1
myrmica New Member Join Date: Apr 2002 Posts: 1	Can histograms with unequal intervals be made in Excel? If not can anyone write a macro to do it? I am a biology teacher interested in computers trying to advise a Maths department!

Apr 30th, 2002, 10:49 AM	#2
Damon Ostrander MrExcel MVP Join Date: Feb 2002 Location: Denver, Colorado USA Posts: 4,014	Hi Gary, Yes, histograms can be done in Excel with unequal intervals, and does not necessarily require the use of macros. How one would do this would depend on how the intervals are specified, how one would want them labeled (assuming they are to be presented graphically), where the data come from, etc. Without more of this kind of information it is difficult to provide specific advice. Damon

Apr 30th, 2002, 11:43 AM	#3
Jay Petrulis MrExcel MVP Join Date: Mar 2002 Location: Chicago, IL USA Posts: 2,042	You may find that Jon Peltier's "Brickyard" chart example to be similar to what you'd want. Not exact, but you may be able to use the techniques. http://www.geocities.com/jonpeltier/...Brickyard.html