• Check out world news on HeadLinesList.com
  • Forum registration is now open for public.
Hello There, Guest! Login Register


Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Microsoft Excel Yr 10 Science EEI?
#1
I have a science assignment (Yr 10) and I need to make a grap using excel. The problem is I don't know how. The results are from a bottle rocket launch, the variable being the amount of water used. We measured the amount of time it took to reach the top of its altitude. Whenever I do what I thought I had to do to make a graph in excel (highlight results table>insert>graph>select graph) it comes up with generic results.
Reply

Ads

#2
Not sure what you mean by "generic results", but this will give you a pretty accurate line graph in Excel. Note, this is for the Microsoft Office 2003 edition, but it should be similar in 2007/2010/2013 versions.

The water used will be on your X (horizontal) axis, while the altitude will be on your Y (vertical) axis. The easiest way to do this is to go Insert>Chart>Line and then a screen will pop up asking for the data range. Then you will highlight the results you have that are in cells. The X variable needs to be on the right, and the Y on the left. After selecting (it also might auto-select), make sure it looks vaguely correct in the preview. If there are two lines, go to Series and delete Series 2.Then it will take you to a window where you will title everything. Name the X axis something like "Water Used (units)" and the Y axis "Altitude (units)" and give the graph itself a fitting title. It will then ask you if you want to insert it as an object for Sheet 1 (or whatever file name you have) or as a new sheet. Select the object in current sheet, and your graph will be there.
Reply

Ads

  


Forum Jump:


Browsing: 1 Guest(s)