SI/engineering prefixes in plots and formatting
- From: Jason Heeris <jason heeris gmail com>
- To: gnumeric-list gnome org
- Subject: SI/engineering prefixes in plots and formatting
- Date: Tue, 14 Jul 2009 11:44:50 +0800
Hi,
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?
I can figure out how to do it for the column of data itself using
lookups, logs and rounding:
=concatenate(text(A2/10^(3*floor(log(A2)/3)),$E$9),lookup(floor(log(A2)),E$3:F$6))
...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
works.
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:
http://mail.gnome.org/archives/gnumeric-list/2004-January/msg00032.html
Cheers,
Jason Heeris
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]