Histogram tool
 

Hi,

I have following bins of horizontal histogram axis: 0,2 0,4
0,6 0,8 1,0 etc. Each value that is not exactly the same as
mentioned bins, e.g. 0,23, Histogram tool puts into an interval "More"
and count its frequency separately.
How can I force Excel count value 0,23 in the interval 0,2-0,4
and not in interval "More"?
Thanks for your help.


--
balcovja
------------------------------------------------------------------------
balcovja's Profile: http://www.excelforum.com/member.php...o&userid=26239
View this thread: http://www.excelforum.com/showthread...hreadid=398524

It is unclear how you arrived at this situation. When I specify similar
bin ranges, the ATP Histogram tool does for me what you say it doesn't
do for you.

You could fix up the table and resulting graph after the fact by
replacing values with appropriate COUNTIF formulas.

Jerry

balcovja wrote:

Hi,

I have following bins of horizontal histogram axis: 0,2 0,4
0,6 0,8 1,0 etc. Each value that is not exactly the same as
mentioned bins, e.g. 0,23, Histogram tool puts into an interval "More"
and count its frequency separately.
How can I force Excel count value 0,23 in the interval 0,2-0,4
and not in interval "More"?
Thanks for your help.