Histogram Bin Error

  • Thread starter Mike - EMAIL IGNORED
  • Start date
M

Mike - EMAIL IGNORED

Excel 2002 (10.6501.6626) SP3

Histogram data appear in the wrong bins. For
example, data belonging in 100-110 appear in
110-120, etc. This is the case for the numeric
results, as well as graphic outputs. Values under
the Series tab of a Column chart can be increased
by one to get a correct plot.

Is there a patch to fix this, or might there be
a user error?

Thanks in advance.
Mike.
 
J

Jon Peltier

Mike -

Did a cell get inserted or added, to cause the bin range and count range
to be offset by a row?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
M

Mike - EMAIL IGNORED

Jon,
I just tried it again on a simple data set.
No extra cells.
Mike.
 
Top