Data Plotting

1
Data Plotting

• Summer Scholars Program

2
Fracture Toughness Results
3
Creating a Graph

• In Excel go to the Insert option and select chart
• In this case choose XY (Scatter) and choose the
  first option
• Hit next then choose the Series tab then Add
• Name the series PS/PS Clay Concentration
  Dependency 6 Min.
• For the X Values choose the column under Clay
  namely 0,1,2,4-20
• For the Y Values choose the column under Gc
  namely 352.6-22.1
• Hit next, then in the Titles tab for Values (X)
  axis write clay , for Values (Y) axis write Gc
  
• In the Legends tab uncheck the Show Legend
  option, since youre only doing one curve.
• In the Gridlines tab make sure everything is
  unchecked, then hit next
• Choose the option As New Sheet, and name it PS/PS
  Clay 6 Min., then hit Finish
• Play around with the graph until you get
  something like this.

4
PS/PS Clay Concentration Dependency 6
Min.
5
Creating Error Bars and Adding a Trendline

• Right Click on any of the data points and choose
  the option Format Data Series
• Click the tab Y Error Bars
• Select Custom then choose the column labeled St
  Dev namely 29.68-1.12, do this for both spaces,
  then hit OK
• Once more Right click on any data point and this
  time select Add Trendline
• Play with the options until you get one you like,
  however as a result of the first data point no
  Trendline will really fit
• The best option is Polynomal and order 3
• The graph should now look something like this

6
PS/PS Clay Concentration Dependency 6 Min.
7
Graphing Exercise 2

• Repeat the same process for the PS/Ps clay
  dependency 2 Min.
• However this time the best trendline is
  Exponential

8
Exponential Determination

• In order to determine if the previous graph
  really has an exponential trandline, you must
  convert the graph into a logarithmic graph.
• Create the graph like the two previous times,
  however this time for Chart Type choose the
  Custom tab and choose the Logarithmic type graph
• Repeat the same process for the rest of the graph
  as for the others
• If your graph comes out to a straight line you
  know the data points are actually exponential if
  not as in our case then the data points are not
  exponential

9
Logarithmic interpretation of PS/PS Clay
Concentration Dependency 2 Min.
10
Multiple Series Graphing

• In order to make a graph with more than one
  series we will change the previous process
  slightly
• This time when making the series add another
  series to your first
• Name the first series PS/PS Time Dependency 5
  Clay Concentration and its appropriate data
  points
• Name the second series PS/PS Time Dependency 10
  Clay Concentration and its appropriate data
  points
• This time keep the legend because you have
  multiple series
• The Trendline for both series Should be Linear
• Your graph should end up looking like this
• (Sidenote) If for some reason you dont want to
  start your X axis at 0 and would rather start it
  with the beginning of the data points, then right
  click on the X Axis and choose Format X Axis, in
  the Scale tab uncheck minimum and write in your
  own minimum, which in this case would be 1

11
PS/PS Time Dependency