Histogram Question, Please

Giganews Newsgroups
Subject: Histogram Question, Please
Posted by:  Bob (rgsros@notme.invalid)
Date: Tue, 04 Jan 2011

Hello,

Using W7 and Excel 2007.

Still a bit uncertain re some of the "nuances" of Histograms, although I
can generate one.

a.  If I have Bins for the data set up as, e.g., 100, 105, 110, 115...

How are data values that has a value of 103, 106, 114, etc. that fall
between handled ? Are they included in a preceding, or following, Bin ?

b.  The columns on the Histogram have "large" horizontal spaces
separating them (the Bins) when plotted.

Any way to make the columns as plotted be essentially contiguous; right
next to each other ?

Thanks,
Bob

Replies