https://bugs.documentfoundation.org/show_bug.cgi?id=115513
Bug ID: 115513
Summary: Chart: Checkbox for zero values to be handled like
missing values in plot options
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Chart
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: thomas.le...@gmail.com
Created attachment 139660
--> https://bugs.documentfoundation.org/attachment.cgi?id=139660&action=edit
Calc example file showing 0 values
When editing data series in a Chart, the Options dialog shows "Plot Options"
with that the presentation of missing values can be configured.
I suggest a checkbox for zero (0) values so that they will be handled like
missing values.
The reason for this request is that I've spreadsheets with several calculated
sums for every year. For example a spreadsheet with data of sold spare parts
per year with own columns for the sum of orders received, invoices, sent
quotations, estimated net profit, etc.
Some sums of the actual year like "sent quotations" can't be finished during
the year. The full information is only available at the end of the year. But I
want to show _not_ zero (0) quotations for this year in the chart. I want that
the chart line ends in the year before so that there is no line in this year
for "sent quotations" if in "plot missing values" the option "Leave gap" is
choosen.
Also 1) I don't want to edit the data range (what is my workaround now) so that
the actual year won't be handled in the chart for this column or 2) I don't
want to edit the formula. The formula and chart should work automatically
without manually "correction" which is the cause for mistakes.
Proposed Data Series Options dialog, Plot Options:
Plot missing values (x) Leave gap
( ) Assume zero
( ) Continue line
[ ] Include values from hidden cells
[ ] Handle zero (0) like missing values <--- new checkbox
Maybe "Assume zero" should be greyed out when activating the new checkbox
because together it doesn't make sense.
In my attached example file I want this option for the green and dark blue and
light blue lines. The lines should end in 2017 because now it's misleading
information. (The yellow and red bar will be filled with data every month, so
they are showing a continual information level.)
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
