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

  • Thread starter Thread starter sp3sp2sp
  • Start date Start date
  • Tags Tags
    Google Graph
Click For Summary

Discussion Overview

The discussion revolves around creating a simple x vs y graph in Google Docs, specifically focusing on the steps required to plot data correctly using a scatter chart. Participants share their experiences and troubleshooting methods related to graphing data points.

Discussion Character

  • Technical explanation
  • Debate/contested

Main Points Raised

  • One participant requests guidance on how to create a basic x vs y graph, expressing frustration with the automatic graph suggestions.
  • Another participant provides step-by-step instructions for creating a scatter chart, emphasizing the need to select the correct chart type.
  • A participant reports successfully creating a scatter chart but encounters an issue with the x-axis being missing, leading to confusion about the data representation.
  • Another participant suggests adding labels to the data columns to potentially resolve the x-axis issue, indicating that this might affect how the data is plotted.
  • A participant describes their own successful attempt at creating a scatter chart, noting the importance of correctly setting the "X-axis" and "Series" in the chart editor.
  • One participant raises a question about whether different programs, like Excel or OpenOffice Calc, might have different functionalities in creating graphs.
  • A participant shares their experience of plotting pressure vs temperature data for a lab experiment, expressing dissatisfaction with the graph's appearance and considering repeating the lab for better results.
  • Areas of Agreement / Disagreement

    Participants generally agree on the steps to create a scatter chart, but there are differing experiences regarding the appearance of the x-axis and how to correctly set up the data ranges. The discussion remains unresolved regarding the best practices for ensuring the x-axis displays correctly.

    Contextual Notes

    Participants mention specific steps and settings in the chart editor, but there are unresolved issues regarding data selection and program differences that may affect outcomes.

    Who May Find This Useful

    Users looking to create graphs in Google Docs, particularly those encountering issues with data representation in scatter charts.

sp3sp2sp
Messages
100
Reaction score
4
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 can't see how to do this. It automatically suggests any graph other than a basic x vs y. Thanks for any help
 
Computer science news on Phys.org
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
 

Attachments

  • graph.gif
    graph.gif
    23.9 KB · Views: 1,390
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
 

Attachments

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.
 
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".
 

Attachments

  • graph2.gif
    graph2.gif
    35.6 KB · Views: 878
  • graph3.gif
    graph3.gif
    32 KB · Views: 1,095
  • graph4.gif
    graph4.gif
    33.1 KB · Views: 829
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.
 
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
 

Attachments

  • chart.png
    chart.png
    2.8 KB · Views: 892

Similar threads

  • · Replies 1 ·
Replies
1
Views
1K
  • · Replies 4 ·
Replies
4
Views
3K
  • · Replies 10 ·
Replies
10
Views
11K
  • · Replies 2 ·
Replies
2
Views
5K
Replies
18
Views
10K
  • · Replies 5 ·
Replies
5
Views
4K
  • · Replies 5 ·
Replies
5
Views
3K
  • · Replies 4 ·
Replies
4
Views
3K
  • · Replies 9 ·
Replies
9
Views
3K
Replies
3
Views
17K