Chart Names

[Tony M]

Hi everyone,

I'm sorry if this is an easy one but I just can't figure
it out.

I have a worksheet with 3 charts on it. I need to write
some VBA to select each chart in turn and change its axis
settings.

So I figured the first thing to do is to name the charts
so that I can select them properly in the VBA. But how do
I name a chart??? If I select the chart I get "Chart Area"
in the name box and I can't edit it.

Many thanks for any help,
Tony M

 

[Debra Dalgleish]

As answered in .programming --

Hold the Ctrl key and click on the chart to select it.
Click in the Name Box, type a new name, then press the Enter key

 

[Tony M]

Thanks Debra, that's great.

Tony M.

-----Original Message-----
As answered in .programming --

Hold the Ctrl key and click on the chart to select it.
Click in the Name Box, type a new name, then press the Enter key




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.

 

[Jon Peltier]

Tony -

If you're doing all the charts, use this so you don't need the names:

For Each oChtOb is ActiveSheet.ChartObjects
With oChtOb.Chart.Axes(1, 1)
...
End With
Next

- Jon