Histogram ?!?

[VBA]

Heya,

I'm trying to make an histogram, but I get totally lost when they ask me to define BIN-numbers. I understand these are the limits between which you wanna count the data. E.g. if I have the numbers 3.8, 4.3, 4.2, 5.1, 5.5, 5.3, 7.1 and the following BIN numbers: 4 5 6 7, I'll find a histogram with frequency 2 for 4 (4.3 and 4.2), frequency 3 for 5 (5.1, 5.5 and 5.3), 0 frequency for 6 and 1 for 7 (7.1).
However, in reality my histogram doesn't even recognize the bin numbers?! It flips when I try to fill in any BIN... it always goes back to default.

I tried to ungo this with the function "frequency", but again it goes wrong with the BIN-array.

Can somebody explain what goes wrong?

I can make histograms by using the COUNT function (defining e.g. COUNTIF(>=4,<5) for the 4-bar in the histogram), but I thought I'd give the add-inn for histograms a chance... Looks like I shouldn't

 

[VoG]

This may help http://www.mrexcel.com/forum/showthread.php?t=363271

 

[Andrew Poulsom]

Here is an example:

http://office.microsoft.com/en-us/excel/HA011109481033.aspx