Issue 29918 - Charts with prefix multipliers (kilo, mega, nano)
Summary: Charts with prefix multipliers (kilo, mega, nano)
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: All All
: P4 Trivial with 3 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: rfe_eval_ok
Depends on:
Reported: 2004-06-06 17:31 UTC by ivand
Modified: 2013-09-25 20:41 UTC (History)
2 users (show)

See Also:
Issue Type: FEATURE
Latest Confirmation in: ---
Developer Difficulty: ---

a chart with prefix multipliers (5.02 KB, image/png)
2004-06-06 17:32 UTC, ivand
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description ivand 2004-06-06 17:31:22 UTC
If you read often some graphs, you know how annoying it is to read numbers like
"914000000". Even "9.14E+8" is not comfortable for making impression of data if
you are doing your daily engineering tasks rather than rocket science. But wait!
"914M" looks much better!
Many Europeans (like me) are rather used to prefix multipliers like "k" for
"kilo~", "M" for "mega~". In informal documents you can see prefixes in
unexpected context like currency. 1 M€ stands for 1,000,000 € indeed. Unix guys
are familiar with "-h" option for "ls" or "df" commands. Electrical engineers
are going insane when they have to read condenser capacities that are usually in
pico~ to micro~ Farads.

I believe that if there was some option to display values on charts with these
prefixes as well (say Scale Property: checkbox "Use Prefix Multipliers"), it
would be a definitive engineer's choice and huge advantage over competitors'
charting tools.

As an example of well-readable graph I am attaching a graph of an audio
measurement made by a specialized software so you can see how easy it is to read
the X scale.

I am sure you guys are familiar with prefixes, but just in case... the URL
points to some article on the topic :-)
Comment 1 ivand 2004-06-06 17:32:08 UTC
Created attachment 15702 [details]
a chart with prefix multipliers
Comment 2 kla 2004-06-08 09:09:14 UTC
kla->bh: I think its an good idea.
Comment 3 bettina.haberer 2004-11-29 18:19:59 UTC
Reassigned to Ingrid.
Comment 4 IngridvdM 2005-04-25 16:01:05 UTC
This looks like a good idea, but details have still to be specified.
Comment 5 differenceengineer 2007-11-08 14:31:28 UTC
I would like to suggest a refinement to this idea. 

I would like this to be an option under "Format Cells" in the "Numbers" tab. I
propose that an additional Category is required called something like
"Engineering" which would mean that a number like 9.14E+8 was displayed as 914M
in the cells of the spreadsheet. If these numbers were used to generate a graph
then the same format could be used.

Comment 6 IngridvdM 2008-07-22 14:20:51 UTC
reset to new