Re: SI/engineering prefixes in plots and formatting

Le mardi 14 juillet 2009 à 11:44 +0800, Jason Heeris a écrit :

Using Gnumeric 1.9.9 under Debian Squeeze (GNOME 2.26.1).

I've been trying to find any information on displaying quantities
using SI/engineering prefixes, especially in plots. Basically, I want
to display my x-axis markers as Hz, 10 Hz, 100 Hz, 1 kHz, 10 kHz, etc.
Is there an way to do this?

Not at the moment. It would need an implementation at the format level.
Please consider filing a bug/enhancement report at

I can figure out how to do it for the column of data itself using
lookups, logs and rounding:


...where $E$9 is a formatting string for the number itself (eg. "0")
and E$3:F$6 is a lookup table for SI prefixes by power of 10. Ugly but

But I can't figure out how (or if it's possible) to do a similar thing
for plots.

I found a discussion from January 04, but no further mention:

Jason Heeris
gnumeric-list mailing list
gnumeric-list gnome org

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