| 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 |
||
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 |
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