I'm trying to make a scatter plot in Numbers but can't get it to work. If I select column A & B and have it make a scatter plot it uses column A for both axes. If I click on the plot and go to Series, it shows the values used for x and y, See the image below.
The above image is what I get when I select columns A and B to try and plot. If I go into that setting box and manually change the y-axis to column B it changes it back to A when I click plot. I tried this several times changing either the x-axis or the y-axis and the same thing happens. It keeps plotting the same values for both x and y.
I can't use a line plot because a line plot assumes the points on the x-axis are evenly spaced and distorts your plot.
An example of the numbers I am trying to plot is given below.
X-values 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 this in numbers?
I've looked at previous questions but none of those answers help me.
tia