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?

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

"cr113" wrote:

>
> 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?
> .
>

On Dec 13, 1:54*pm, Paul <P...@discussions.microsoft.com> wrote:
> 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.


>
>
>
> "cr113" wrote:
>
> > 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?
> > .- Hide quoted text -
>
> - Show quoted text -