Graphing data is important because it allows us to visualize the relationship between the data and calculated values.
We are now going to graph Force vs Acceleration
Select cells D8 through E17
Select the insert tab from the top of the excel window
In the chart box click on Scatter
Choose Scater with Markers Only
A chart should appear
In the design tab under chart layout
Choose layout 1
In the graph double click on chart title and change it to "Force vs Acceleration"
Double click on the x axis title and change it to "Acceleration (m/s2)
Note: To superscript the 2 you need to click on the home tab of the
main menu and then expand the Font Box so that you can check the
superscript box.
Double click on the y axis title and chang it to "Force (kg m/s2) Note: Again superscript the 2.
Add a trendline by right clicking on one of the data points and choosing "Add Trendline"
In the add trandline window
Click on the trendline equation text box and move it to the upper right hand corner of the graph window.
Right click on the legend on the right hand side of the graph and select delete.
Right click on one of the x axis values and then select "Add Major Gridlines"
If
you wanted to paste this into a word document you could copy and past
the graph from here to the word document. If you are going to print the
graph as its own page (which you are doing for this assignment) do the
following :
Right click in the lower left hand corner and select "Move Chart...
Select "New Sheet
Title it "Force vs Acceleration"
Click OK
In the new window, right click on the "y-axis"
Choose format axis
Under Axis Options
Change Major units to fixed
Change the value to 5
Click close
Right click on sheet tab 2 and select delete
Right click on sheet tab 3 and select delete
Right click on sheet tab 1 and select rename
Type "Data"
Select the Data Tab
We will now make an inverse square graph.
Select C8 through D17
Insert a Scatter With Only Marks Graph
Title this Acceleration vs Time
Label the x-axis as Time (s)
Label the y-axis as Acceleration (m/s2)
Delete the Legend
Right click on a Data Point
Add trendline
Chose a power function under regression type
Diplay Equation
Display R-squared
Move the equation box to the upper right hand corner.
Move the graph to a new sheet
Name it : Acceleration vs Time
Right click on an x-axis unit
Add major gridlines
Right click on an x-axis unit again
Select Format Axis
Change the major axis to fixed with 0.1 increments
Right click on the a y-axis unit again
Select Format Axis
Change the major axis to fixed with 1.0 increments
