VBA refer to chart name
<p>Why this does not work:</p>

<pre><code>ActiveSheet.ChartObjects("Sale").Axes(xlValue).MinimumScale = 1000
</code></pre>

<p>while this does:</p>

<pre><code>  With ActiveChart.Axes(xlValue, xlPrimary)
    .MinimumScale = 1000
  End With
</code></pre>

<p>First I did this:</p>

<pre><code>ActiveChart.Parent.Name="Sale"
</code></pre>

<p>I was not able to do this:</p>

<pre><code>ActiveChart.Name="Sale"
</code></pre>

<p>I want to refer specifically to the chart "Sale", not to ActiveChart.</p>