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: https://wiki.documentfoundation.org/U...
Whiteboard: BSA
Keywords:
: 156878 (view as bug list)
Depends on:
Blocks: Chart Chart-Enhancements
  Show dependency treegraph
 
Reported: 2013-08-20 20:49 UTC by kgizdov
Modified: 2024-05-15 11:49 UTC (History)
9 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
Missing 'display units' feature Excel vs Calc 24.2 (75.51 KB, image/png)
2024-05-15 11:45 UTC, Piotr Osada
Details
tdf#68354 Chart with Multiplier 'display units'.xlsx (19.71 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2024-05-15 11:47 UTC, Piotr Osada
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 [retired] 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
Comment 6 907shane@gmail.com 2022-01-25 03:07:31 UTC
Why is this not a priority? This is pretty basic plotting, and breaks almost all of my spreadsheets coming over from Excel. To not be able to scale the values in a series for the Axis labels is a pretty big oversight. The alternative is to create a separated data column that is formatted as you want it for the Axis labels, instead of a check box and dropdown in the Scale tab of the Axis Format dialog. PLEASE, can't someone implement this!
Comment 7 907shane@gmail.com 2022-01-25 03:08:56 UTC
I just noticed this was first posted in 2013!
Comment 8 Gabor Kelemen (allotropia) 2023-08-24 13:12:49 UTC
*** Bug 156878 has been marked as a duplicate of this bug. ***
Comment 9 Piotr Osada 2024-05-15 11:45:08 UTC
Created attachment 194126 [details]
Missing 'display units' feature Excel vs Calc 24.2

I agree with previous voices that this functionality is vital for Calc usability. As of my quick research, it's available in Excel since at least 2003 version of MSO.

Example tutorials:
https://www.youtube.com/watch?v=IaJlZTieDWc
https://www.exceldemy.com/excel-chart-data-labels-in-millions/

https://web.archive.org/web/20060114000912/http://www.officearticles.com/excel/millions_and_thousands_in_charts_in_microsoft_excel.htm
Comment 10 Piotr Osada 2024-05-15 11:47:13 UTC
Created attachment 194127 [details]
tdf#68354 Chart with Multiplier 'display units'.xlsx