Re: Histogram "Bins" tab options problem
- From: "Andreas J. Guelzow" <aguelzow pyrshep ca>
- To: "Daniel P. Dougherty" <doughe57 msu edu>
- Cc: gnumeric-list gnome org
- Subject: Re: Histogram "Bins" tab options problem
- Date: Tue, 08 Feb 2011 14:21:16 -0700
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
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!)
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
] [Thread Prev