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.
Version: 22.214.171.124 (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
Reported on macOS, confirmed on Windows, so setting OS to all