How to change chart properties.

[cr113]

Suppose you insert 2 charts "non programmatically" in an Excel
worksheet (click Insert>Column>Stacked Colum for example). How would
you change the chart properties programmatically? I've used the shapes
collection, but that only worked for me with one chart. The problem is
that I don't know how to differentiate between multiple charts. Is
there some way to name the chart or shape somehow?

 

[Paul]

For all this type of action try recording a macro which selects your chart,
then changes the relevant properties.

 

[cr113]

For all this type of action try recording a macro which selects your chart,
then changes the relevant properties.

The macro doesn't seem to record anything after you select the chart.

This is all I get:

ActiveSheet.ChartObjects("Chart 1").Activate

I think the real question is how can I rename a chart? That would
solve the problem.