Re: Histogram "Bins" tab options problem

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.

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

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.


[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]