Bug 125750 - PIVOTTABLE scatter chart
Summary: PIVOTTABLE scatter chart
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Pivot-Chart
  Show dependency treegraph
Reported: 2019-06-06 16:42 UTC by David
Modified: 2023-12-27 12:24 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Relevant sheets: Pivot Table_Data_1 refers to data in sheet "Data", which depends on information in the sheets "Concours types" and "Zones". (574.79 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-06-06 16:42 UTC, David

Note You need to log in before you can comment on or make changes to this bug.
Description David 2019-06-06 16:42:25 UTC
Created attachment 151987 [details]
Relevant sheets: Pivot Table_Data_1 refers to data in sheet "Data", which depends on information in the sheets "Concours types" and "Zones".

The XY scatter plot does not work correctly when plotted from a pivot table.  The chart on the sheet "Pivot Table_Data_1" in the attached file is plotted as if it was a Line Chart, with the X-axis labeled with the numbers of the points.

The pivot table data has been copied and pasted as static data in the sheet "Static Data". When charting this exact same data with an XY scatter plot, it is correct.
Comment 1 m_a_riosv 2019-06-07 00:52:39 UTC
Version: (x64)
Build ID: 2412653d852ce75f65fbfa83fb7e7b669a126d64
CPU threads: 4; OS: Windows 10.0; UI render: GL; VCL: win; 
Locale: es-ES (es_ES); UI-Language: en-US
Comment 2 eisa01 2019-08-31 12:50:32 UTC
Reported on macOS, confirmed on Windows, so setting OS to all
Comment 3 QA Administrators 2021-08-31 03:55:06 UTC Comment hidden (obsolete)
Comment 4 GfEw 2021-12-25 21:16:59 UTC
I found this in the aftermath of my unresolved question at https://ask.libreoffice.org/t/pivot-table-chart-how-to-enforce-linear-x-axis-pace-across-skipped-rows/ .

This bug is still present in LO version, build ID 20, at Linux 4.15.
Comment 5 QA Administrators 2023-12-27 03:09:44 UTC Comment hidden (obsolete)
Comment 6 Andreas Säger 2023-12-27 12:24:37 UTC
Still in

Version: (X86_64) / LibreOffice Community
Build ID: e19e193f88cd6c0525a17fb7a176ed8e6a3e2aa1
CPU threads: 4; OS: Linux 5.15; UI render: default; VCL: x11
Locale: de-DE (de_DE.UTF-8); UI: en-US
Calc: threaded