VBA Chart Code

nigelk · Apr 13, 2011

Hi all,

I've recorded some code:

Code:

   ActiveSheet.ChartObjects("Chart 7").Activate
   ActiveChart.Axes(xlValue).MinimumScale = 1

but when I change it to:

Code:

ActiveSheet.ChartObjects("Chart 7").Axes(xlValue).MinimumScale = 1

it fails. Can anyone tell me why?

Thanks,Nigel

doofusboy · Apr 14, 2011

Most likely it fails because the ChartObjects object does not contain an 'Axes' property the way an ActiveChart object does.

Andy Pope · Apr 14, 2011

Code:

ActiveSheet.ChartObjects("Chart 7").Chart.Axes(xlValue).MinimumScale = 1

RoryA · Apr 14, 2011

Andy,
Your new title still makes me laugh.

Nice to know we achieve something in those Thursday sessions.