Hi,

Have you tried using the macro recorder to get an idea of the syntax?

I got this,
Charts("Chart1").ChartObjects("Chart 1"). _
Chart.ChartArea.AutoScaleFont = False

Cheers
Andy

Hari Prasadh wrote:
Hi,

Whats the correct syntax to access (activate) a chart within a chart sheet
in an excel workbook?

I tried

Sheets("Chart1").Chartobjects("Chart 5").activate

Also,

Charts("Chart1").Chartobjects("Chart 5").activate

But both of them gave run-time error.

Basically I want to select a single chart within a chart sheet and change
the Auto-Scale property to False.

(I need to ultimately do this within all Excel Chart OLE's within a PPT, so
my syntaxes actually have the name of the PPT session along with object name
appended to them.)

Regards,
Hari
India



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info