Data points are not moving on the X Axis Scatter Plot in Excel

Question

I have an excel scatter plot which is working for the Y axis but not the X Axis. If I change the Y values the data point moves accordingly. However, the X axis seems to be fixed in positions. The closest thing I can identify to logic is that the first number in the series is the X axis as 1, the next is 2, 3, 4, and so on

I would like (5.6,3) to show up at (5.6,3) not (1,3) because it's the first in the series.

Example for X axis theory:

Series 
X ------ Y ------ graph placement
.6 ----- 3 ------ (1,3)
1.2 ---- 3.4 ---- (2,3.4)
.8 ----- 5.2 ---- (3,5.2)

notice the X coordinates 1,2,3 are moving sequential with their placement in the series.

Example for Y axis working:

(1.333,1) is placed at (3,1) on the plot. If I change it to (1.333,2) then it goes to (3,2). The X Axis changes do not move the point.

Answer 1

I give up. On the right is a chart that I think represents what you are seeing, driven by the data as shown which includes a single inverted comma I prefixed 1.333 with. On the left I overlaid an image of the chart I see without that inverted comma - and I think represents what you want: