Naming a chart object

[martinu]

When charts are created they are named "chart 1", "chart 2", and so on
I need to name a chart in order to update it from vba, but when
select the chart I cannot click in the name box? Help

 

[Ed Ferrero]

Hi martinu,

To rename a chart, hold the shift key down and select the chart.
This selects the chart object instead of the chart area. You can
then rename as usual.

 

[martinu]

Thanks Ed, so simple when you know how.