Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

How to make a simple x vs y graph in Google docs

  1. Oct 13, 2018 at 2:20 PM #1
    If I select two columns of data what are the steps to make a simple x vs y graph of that data? I know its sort of a dumb question but i cant see how to do this. It automatically suggests any graph other than a basic x vs y. Thanks for any help
     
  2. jcsd
  3. Oct 14, 2018 at 8:01 AM #2

    jtbell

    User Avatar

    Staff: Mentor

    I assume you want the data displayed as points rather than lines, bars, wedges, etc.

    Select the data you want to plot.
    In the menu at the top, choose Insert --> Chart. The default is a line graph.
    In the Chart Editor, choose Data --> Chart type --> Scatter chart. This gives you points instead of a line.

    graph.gif
     
  4. Oct 14, 2018 at 10:27 AM #3
    Thanks for the steps jtbell appreciate it. I did exactlt as you specified and I can get the scatter chart but the x-axis is always missing. I attached pic of what it looks like. Its just random numbers. Thanks for any more help
     

    Attached Files:

  5. Oct 14, 2018 at 11:41 AM #4

    jtbell

    User Avatar

    Staff: Mentor

    That looks like it's plotting the x and y values separately, blue and red respectively. I have to go out soon, but later today I'll try to reproduce your result and see how the steps differ from the way I made my plot.

    In the meantime, try adding labels to the top of each column of data (like my x and y) and include them when you select the data. Maybe that makes a difference.
     
  6. Oct 14, 2018 at 3:39 PM #5

    jtbell

    User Avatar

    Staff: Mentor

    I tried to copy your data by reading the x and y values from your graph. Here's what I got immediately after choosing Insert --> Chart:

    graph2.gif

    Then after changing it to a scatter chart, without touching any of the other settings in the chart editor:

    graph3.gif

    As you can see, I have both x and y axes, and a single set of points. In the chart editor, there are ranges for "X-axis" and "Series". I bet you have a blank "X-axis" and two "Series".

    [added] Aha! I deleted the "X-axis" range in the chart editor, and added a second "Series" with the range A2:A7:

    graph4.gif
    The graph looks like what you have, except that the colors are switched. If you have something similar in the chart editor, try deleting one of the "Series" and putting it in the "X-axis".
     
  7. Oct 14, 2018 at 3:59 PM #6

    Borek

    User Avatar

    Staff: Mentor

    Wouldn't hurt to know what program do you use. For example I am not 100% sure Excel and OpenOffice Calc work the same way.
     
  8. Oct 16, 2018 at 11:08 PM #7
    Thank you again for this help. I finally found out that if I select data columns in separate steps then it will plot the points and plot line.
    Im trying to plot pressure vs temp to extrapolate value for absolute zero, but the graph looks pretty bad with the values i got from lab. I think I should repeat lab
    btw Borek this is all in google docs. chart.png
     
Share this great discussion with others via Reddit, Google+, Twitter, or Facebook

Have something to add?
Draft saved Draft deleted