So I am trying to convert some data into a scatter plot using Google Sheets. I have 2 problems:
When I try and order the x and y so that the graph has x data on x and y on y it inverts it. May this be related to the fact that the y-axis data is of smaller values? 1.4-3.5 instead of 44k etc.?
If the solution is to just switch x and y from the editor instead of switching the side of the data how do I do that?
I would like GDP per capita to be on the x and height to be on the y