title: Extracting R-square from Chart into cell
body: <p>I have an Excel scatter chart, that has a trendline and R2 value.  </p>
  
  <p>How can I return the R-squared value of the trendline to a variable?  </p>
  
  <p>I thought:</p>
  
  <pre><code>x = ActiveChart.SeriesCollection(1).Trendlines(1).Datalabel.Value
  </code></pre>
  
  <p>but this doesn't work.</p>
  
  <p>I know we can calculate directly using RSQ and LINEST, but when intercept is taken zero value form chart is not same as calculated through LINEST. And I want to document the values from chart.</p>