https://bugs.documentfoundation.org/show_bug.cgi?id=164027

            Bug ID: 164027
           Summary: [Feature Request] Bar/Column chart: Checkbox for
                    relative difference of values
           Product: LibreOffice
           Version: 24.8.2.1 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: [email protected]
          Reporter: [email protected]

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

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to