How to change chart properties.

  • Thread starter Thread starter cr113
  • Start date Start date
C

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?
 
For all this type of action try recording a macro which selects your chart,
then changes the relevant properties.
 
For all this type of action try recording a macro which selects your chart,
then changes the relevant properties.
Click to expand...

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.
 
Back
Top