The data in the sheet must be given in a certain order to get charts with correct values.
Example 1: Data grouped by rows
The x and y values have to be entered one below the other, as in the screenshot below:
Data area for the chart: A1:B7
Chart type: XY (Scatter) 
Data grouped by: Rows
Series labels: Auto
Category labels: Auto
Format numbers x axis: Percent
Format data series: changed colors
Entry for chart title: Turnover
Result: XY Scatter chart above.
Example 2: Data grouped by columns
The x and y values have to be entered one after the other, as in screenshot below:
Data area for the chart: A1:G2
Chart type: XY (Scatter) 
Data grouped by: Columns
Series labels: Auto
Category labels: Auto
Format numbers x axis: Percent
Format data series: Changed colors
Entry for chart title: Turnover
Result: XY Scatter chart above.
Updated March 27, 2024