title: How to export Chart via name reference
body: <p>I have several charts on one of my sheets (charts) and I only want to export 6 specific charts. When I select a chart and go to the <code>Layout</code> tab I see something called <code>Chart Name</code> which I assume lets me choose the chart name. I've tried changing the name to "ChartA" for one of the charts. Please help with this simple VBA code.</p>
  
  <pre><code>Sub SaveJPGTest()
  Chart("ChartA").Export "Z:\specialChart.jpg"
  End Sub
  </code></pre>