Re: Histogram "Bins" tab options problem

["Andreas J. Guelzow" <aguelzow pyrshep ca>]

On Tue, 2011-02-08 at 14:51 -0500, Daniel P. Dougherty wrote:
> The other issue is that the bin labels created by the Histogram process appear 
> as english words

note that they only "appear as english words". They are numbers.
> Histogram             
>               0.22251744455154
> above 0.02077103504058        up to 0.12736215860097  8.3%
> above 0.12736215860097        up to 0.23395328216135  16.7%
> above 0.23395328216135        up to 0.34054440572173  8.3%
> above 0.34054440572173        up to 0.44713552928211  0.0%
> above 0.44713552928211        up to 0.55372665284249  0.0%
> above 0.55372665284249        up to 0.66031777640287  16.7%
> above 0.66031777640287        up to 0.76690889996325  16.7%
> above 0.76690889996325        up to 0.87350002352363  16.7%
> above 0.87350002352363        up to 0.98009114708401  8.3%
>
> All of the "above..." in one column and "up to ..." in the next column over 
> makes it difficult to make decent X-axis labels for "Column chart"  (see 
> attached image).  

It isn't really that hard. Just reformat the numbers to whatever you
like!


> You also can't apply the number formatting tools to this 
> text (e.g. "Scientific notation" or certain number of decimals etc)

Why not? Did you try? There is no text (that's all an illusion!)

> This really 
> needs to be fixed some how.  

there is nothing broken here, I think .

> Possible solution might be to label the bin 
> center?? Possibly at a third column with the bin center so the user (at their 
> option) can use the bin center as a label??

It is easy enough to add a column after the fact for that purpose.
Remember this is a spreadsheet.

>  
>
> My sense is that the current labeling scheme for histogram will seem at odds 
> with what a typical end-user would/will expect/want.

I don't see how. Since these are numbers you can always format them as
you like.

Andreas
>