Problem:
If you add lines to connect points on an XY chart, then the chart is not treated as XY Scatter any more.

The following example tries to run ChangeXY function.

Solution:
You need to re-format the series to get rid of the lines.