title: Calculating Angle/Rate of Climb of a Line in Spotfire and Excel
body: <p>I am looking to calculate the angle of climb / slope of multiple lines in Spotfire (calculated columns) as well as Excel.</p>
  
  <p>On the graph (attached) I would like to be able to color the lines by their continuous angle of climb / slope values. I.e., where the angle of climb is steep it is one color, where the curves have shallower climbs, there is another color.</p>
  
  <p>How would I calculated these as values (per location) as a calculated column in Spotfire, and in Excel? </p>
  
  <p>Here are the values that were use to make the graph.</p>
  
  <p>Location,Var X,Var Y</p>
  
  <p>A,0,0</p>
  
  <p>A,0.02,0.08</p>
  
  <p>A,0.08,0.16</p>
  
  <p>A,0.2,0.21</p>
  
  <p>A,0.25,0.28</p>
  
  <p>A,0.34,0.35</p>
  
  <p>A,0.421,0.42</p>
  
  <p>A,0.502,0.83</p>
  
  <p>A,0.583,0.86</p>
  
  <p>A,0.664,0.89</p>
  
  <p>A,0.745,0.92</p>
  
  <p>A,0.826,0.95</p>
  
  <p>A,1,1</p>
  
  <p>B,0,0</p>
  
  <p>B,0.13,0.08</p>
  
  <p>B,0.29,0.16</p>
  
  <p>B,0.31,0.21</p>
  
  <p>B,0.35,0.28</p>
  
  <p>B,0.42,0.35</p>
  
  <p>B,0.43,0.42</p>
  
  <p>B,0.59,0.49</p>
  
  <p>B,0.63,0.56</p>
  
  <p>B,0.7,0.58</p>
  
  <p>B,0.78,0.62</p>
  
  <p>B,0.85,0.65</p>
  
  <p>B,1,1</p>
  
  <p><a href="https://i.stack.imgur.com/K0lIp.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/K0lIp.png" alt="enter image description here"></a></p>