Description: If you want to create a bar chart, you can only have the values alligned to the 0 value, but not in relative position to each other. Example: minus-max: -9, minus-average: -5, plus-average: 15, plus-max: 25 You can create a chart with values next to each other in bars (which is not how this should be displayed). You can also create a stacked bar chart, but the chart goes from ca. -9 to 0 and from 0 to 15 (which is also not the way the example should be displayed). Additionally, the stacked chart calculates the last value as an addition for some reason (so the last value is 40 (=15+25) and not 25). My suggestion would be Steps to Reproduce: 1. Enter values (per the example) 2. Create chart (eg. column) Actual Results: I can only display the values side by side or stacked with the need of recalculating the values if I want them to show up right. Expected Results: A checkbox that makes the chart values be calculated in relative position to each other. So bar segment 1: -9 to -5, second bar segment -5 to 15, third bar segment 15 to 25 Reproducible: Always User Profile Reset: No Additional Info: Version: 24.8.2.1 (X86_64) / LibreOffice Community Build ID: 0f794b6e29741098670a3b95d60478a65d05ef13 CPU threads: 12; OS: Linux 6.8; UI render: default; VCL: gtk3 Locale: de-AT (de_AT.UTF-8); UI: de-DE Flatpak Calc: threaded
Created attachment 197765 [details] example file File for the provided example (-9, -5, 15, 25) as column bar or stacked column bar.
See also video https://www.youtube.com/watch?v=5zBg9pH_6bE about this issue
General note: Before writing this request I searched several sources, but I couldn't find an answer for this. I checked help.libreoffice.org as well as ask.libreoffice.org without any information to be found. - https://help.libreoffice.org/latest/en-GB/text/schart/01/type_column_bar.html?DbPAR=CHART#bm_id4919583