0

So I am trying to convert some data into a scatter plot using Google Sheets. I have 2 problems:

  1. 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.?

  2. 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?

Data:

sample data

I would like GDP per capita to be on the x and height to be on the y

  • share a copy of your sheet – user0 Mar 25 at 7:06
1

Welcome. We can't be sure, since you haven't shared a sample file with us, but this type of odd graphing usually comes from bad input. In this case, I'm guessing it's your units being part of the data—Sheets is charting literal strings of text.

Change your height values to just numbers, and if that doesn't automatically fix it, delete and create the chart again.

Since you're now missing your labels, either

  • change the header to "Average Height/Country (m)" or
  • select all the numbers in that column and up in the menus, choose Format→Number→More Formats→Custom Number Format and enter format #.##" m" in the Custom Number Format field at the top. The values are still raw numbers, but they're displayed with the unit included.
  • Ok I will try this thanks! – Outsider Mar 25 at 16:19

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.