title: VBA-charts: how to read the formula from a chart Series
body: <p>how can I read back the formula that has been assigned to any of the chart series properties?
  i.e. when I have a simple x-y scatter chart, I can assign a formula to the Name property</p>
  
  <pre><code>ActiveChart.FullSeriesCollection(1).Name = "=Sheet2!$D$1"
  Debug.Print ActiveChart.FullSeriesCollection(1).Name 
  ' DOES NOT Print =Sheet2!$D$1, but the value in that cell
  </code></pre>
  
  <p>the problem is, that when I read it later, it always returns the value of the formula, not the formula itself.</p>
  
  <p>any ideas?</p>