Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

oldschool

macrumors 65816
Original poster
How can I go about making a graph? I have a set of data that needs to be plotted.

I have some X-values, and some Y values, and they need to get into a line graph format.

Sure i could do this by hand, but I want my report to look professional. So far I have had no luck with excel....i feel really stupid right now.

can someone give me a hand?
 
How about Word? There's a chart feature built-in that I have used before. I believe it is under Insert | Picture | Chart.
 
In Excel, setup you x-values in the first colum, and the y-values in the second colum (see picture). Select only the numbers, like in the picture (you don't need the labels at the top). Then go to the chart wizard (see second picture) and select "XY-Scatter". You can then choose whether you want your data points show up on the graph, ect. Keep hitting "Next" and you can assign labels, ect.
 

Attachments

  • Picture 1.jpg
    Picture 1.jpg
    28.9 KB · Views: 214
  • Picture 2.jpg
    Picture 2.jpg
    35.4 KB · Views: 9,922
MoparShaha said:
In Excel, setup you x-values in the first colum, and the y-values in the second colum (see picture). Select only the numbers, like in the picture (you don't need the labels at the top). Then go to the chart wizard (see second picture) and select "XY-Scatter". You can then choose whether you want your data points show up on the graph, ect. Keep hitting "Next" and you can assign labels, ect.


wow. thank you very much MoparShaha. You made an actual tutorial with graphics and everything.

Thanks.
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.