https://bugs.documentfoundation.org/show_bug.cgi?id=166584
Bug ID: 166584
Summary: PivotCharts use date values in X axis as labels rather
than actual dates
Product: LibreOffice
Version: 25.2.2.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Chart
Assignee: [email protected]
Reporter: [email protected]
Created attachment 200813
--> https://bugs.documentfoundation.org/attachment.cgi?id=200813&action=edit
ODF book showing the "actual" and "expected" behaviours.
Hello,
I've recently tried to represent a timeline with a Pivot Chart and found that
Calc seems to handle date values as text labels rather than dates.
If the data samples contain date gaps (for example, one or two months without
any samples), then the Pivot Chart will have all dates consecutive in the X
axis. In this case, the expected behavior would be to have a chart showing the
gaps in the X axis.
With the same data, but manually arranged as the Pivot Table does, a regular
chart is rendered just as expected, without the need to configure any property.
I've prepared a sample ODF book with an "actual" and "expected" sheets showing
this behavior.
Thank you and kind regards,
Guillermo
--
You are receiving this mail because:
You are the assignee for the bug.
