VBA refer to chart name

Question

Why this does not work:

ActiveSheet.ChartObjects("Sale").Axes(xlValue).MinimumScale = 1000

while this does:

  With ActiveChart.Axes(xlValue, xlPrimary)
    .MinimumScale = 1000
  End With

First I did this:

ActiveChart.Parent.Name="Sale"

I was not able to do this:

ActiveChart.Name="Sale"

I want to refer specifically to the chart "Sale", not to ActiveChart.

Answer 1

A ChartObject is just a "container" for a Chart on a worksheet: you need to access its Chart property to get to the chart itself:

ActiveSheet.ChartObjects("Sale").Chart.Axes(xlValue).MinimumScale = 1000