Histogram

D

durino13

I have a array of values, for instance: 1 2 3 4 5 6 atc. As soon as I
want to create a histogram, everything is working well, till I
explicitly write down the bin values ...

But when I do not tell to excel the bin range, excell tryies to find
this range automatically. The problem is, that excel did not find the
values from the array, like 1 2 3 4 5 6, but instead of them, he
resolves something like 1 | 2,33333 | 3,66666 atc ...

I have also changed the format of the array to numbers with a one
decimal place, but it did not solve my problem

Any idea?
 
D

Dave Peterson

If excel can't find the bins range, it says this in help:

If you omit the bin range, Excel creates a set of evenly distributed bins
between the data's minimum and maximum values.

So type in the address of that bins range and see what happens.
 
D

durino13

So according to this, the only way, how to force excel to take prope
values is to explicitly write down the bin array ...

So my second question is, how can I find out the sorted array o
values, where the values will be unique and sorted?

Something like this:

I have an array: 1 3 5 7 10 10 1 3 2

The result should be like this: 1 2 3 5 7 10, it means sorted an
unique ...

Is there a function for this
 
D

Dave Peterson

Maybe just recording a macro when you do it manually--then rerunning that macro
when you need it would be sufficient.
 
Top