So I'm trying to convert some data into a scatter diagram using the Google sheets. But 2 problems:
when I try and order x and y so that the graph has data of x in x and y in y, it inverts it. Can this be related to the fact that the y-axis data are of smaller values? 1.4-3.5 instead of 44k ect.
If the solution is simply to change the editor's x and y instead of changing the data side, how can I do that?
I would like the per capita GDP to be in the x and the height be in the y