Histogram And Bin Size ?

  • Thread starter Thread starter Bob
  • Start date Start date
B

Bob

Hello,

Using W7 and Excel 2007.

I want to produce a Histogram chart from a large column of data.
The spreadsheet has a large column of dates (sequential, but arbitrary),
and next to each date there is a number.

I have the range for the data set up, (not interested in the dates
column at all for the Histogram) and, yup, Excel actually produces a
quite nice Histogram.

But, this is if don't enter a number for BIN.
It selects a Bin size by itself, but it ends up as a number like 5.675

I guess I am very confused over how I can tell it to use a particular
Bin size. I would just like a nice "clean" integer like 5, without the
decimal part, for the Bin size width.

How do I do this, please ?

Thanks,
Bob
 
Hello again,

I realize that I probably didn't explain my just previous Post very well.

For the bin sizes, I would like to select, and have plotted, bins like
the following:

120-125
125-130
130-135
135-140

and not:
120.342-125.453
etc.

Thanks,
Bob
 
Back
Top