Histogram

[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?

 

[durino13]

It is quite important for me

 

[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.

 

[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

 

[Dave Peterson]

I'd use data|filter|advanced filter.
Copy the unique records to a different location and sort that range.

Debra Dalgleish has some nice instructions at:
http://www.contextures.com/xladvfilter01.html#FilterUR

 

[durino13]

Thanx for response, but I need to do this automatically, not manually
....

 

[Mike Middleton]

durino13 -

My free Better Histogram add-in is available at www.treeplan.com. The VBA
code is not protected. You may be able to adapt some of the add-in's
methodology and code to help you solve your problem.

- Mike
www.mikemiddleton.com

 

[Dave Peterson]

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