Download it now!
Bug 68354 - FORMATTING: Feature Request: Ability to scale axis in thousands, millions, etc., basically in different scale than just units
Summary: FORMATTING: Feature Request: Ability to scale axis in thousands, millions, et...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Chart (show other bugs)
Version:
(earliest affected)
4.1.0.4 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks: Chart-Enhancements
  Show dependency treegraph
 
Reported: 2013-08-20 20:49 UTC by kgizdov
Modified: 2020-07-20 08:39 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:


Attachments
Example file from Excel with all possible options (44.78 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2020-05-28 09:49 UTC, NISZ LibreOffice Team
Details
How the example file looks in Excel (119.36 KB, image/png)
2020-05-28 09:50 UTC, NISZ LibreOffice Team
Details

Note You need to log in before you can comment on or make changes to this bug.
Description kgizdov 2013-08-20 20:49:34 UTC
Problem description: 
There exists no way of formatting any axis in a chart such that it shows steps of thousands, millions, etc., anything different than units. For example, a data set has X-values of 10 000, 20 000, 30 000 and so on, the X-axis on the chart shows a scale of 10 000, 20 000, 30 000 and so on, instead of showing 10, 20, 30,... thousands at the end.

Current behavior:
Unsatisfactory

Expected behavior:
Mimic the same ability of Microsoft Office Excel in order to save space and avoid heavy clutter that ultimately ruins a useful chart
              
Operating System: Windows 7
Version: 4.1.0.4 release
Comment 1 Thomas van der Meulen 2013-08-21 05:53:32 UTC
That sounds like a great idea, setting it to new, all OS's & enhancement.
Comment 2 bruno.binet 2014-04-28 19:51:30 UTC
In fact, it should be possible to scale with any power of 10. For example, if the values are between 1E-12 and 9E-12, it should be possible to scale from 1 to 9 (and show the power at the end in a elegant way in words or scientific notation). This would be BETTER than Excel.
Comment 3 bruno.binet 2017-03-08 01:23:54 UTC
Still very interested by this enhancement
Comment 4 NISZ LibreOffice Team 2020-05-28 09:49:49 UTC
Created attachment 161359 [details]
Example file from Excel with all possible options
Comment 5 NISZ LibreOffice Team 2020-05-28 09:50:26 UTC
Created attachment 161360 [details]
How the example file looks in Excel