Summary: | FORMATTING: Feature Request: Ability to scale axis in thousands, millions, etc., basically in different scale than just units | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | kgizdov <kgizdov> |
Component: | Chart | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | ||
Severity: | enhancement | CC: | bruno.binet, gerald, kelemeng, libreoffice, nemeth, piotr.osada, pje335-lo, tundeth, varga.balazs3 |
Priority: | medium | ||
Version: | 4.1.0.4 release | ||
Hardware: | All | ||
OS: | All | ||
URL: | https://wiki.documentfoundation.org/Unimplemented_Chart_ODF_Elements | ||
See Also: | https://bugs.documentfoundation.org/show_bug.cgi?id=74112 | ||
Whiteboard: | BSA | ||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 90486, 108538 | ||
Attachments: |
Example file from Excel with all possible options
How the example file looks in Excel Missing 'display units' feature Excel vs Calc 24.2 tdf#68354 Chart with Multiplier 'display units'.xlsx |
Description
kgizdov
2013-08-20 20:49:34 UTC
That sounds like a great idea, setting it to new, all OS's & enhancement. 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. Still very interested by this enhancement Created attachment 161359 [details]
Example file from Excel with all possible options
Created attachment 161360 [details]
How the example file looks in Excel
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! I just noticed this was first posted in 2013! *** Bug 156878 has been marked as a duplicate of this bug. *** 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 Created attachment 194127 [details] tdf#68354 Chart with Multiplier 'display units'.xlsx |