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 > > > _______________________________________________ gnumeric-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnumeric-list
