Graphing Data

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
Scatter Plot Choice


  • A chart should appear
  • In the design tab under chart layout
  • Choose layout 1
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 
Trendline 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
Move Chart

  • In the new window, right click on the "y-axis"
  • Choose format axis
Format Axis
  • Under Axis Options
  • Change Major units to fixed
  • Change the value to 5
  • Click close
Major Units

  • 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
  • SAVE YOUR WORK