I am trying to create a point cloud in Numbers, but I can't seem to get it to work. If I select columns A and B and create a scatter plot, it uses column A for both axes. If I click on the plot and go through a series, it shows the values used for x and y, see the image below.
The image above is what I get when I select columns A and B to try to plot. If I go to this setting box and manually change the y-axis on column B, it returns to A when I click on the plot. I have tried several times to change the x-axis or the y-axis and the same thing happens. It continues to plot the same values for x and y.
I cannot use a line plot because a line plot assumes that the points on the x-axis are evenly spaced and distorts your plot.
An example of the numbers I am trying to trace is given below.
Values X 1,2,5,7,8,9
Y values 43.56,103,156,215,300
I just want a simple x, y plot … Can anyone do that in numbers?
I have looked at the previous questions but none of these answers help me.