Created attachment 200813 [details] 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
Maybe the issue comes from dates being as text in the Pivot Tables. Version: 25.2.3.1 (X86_64) / LibreOffice Community Build ID: d8d1af5f77df955194e52baabe19324532ac8e8b CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 26100); UI render: Skia/Raster; VCL: win Locale: en-US (es_ES); UI: en-US Calc: CL threaded