Jeff -

Sounds like the chart's window is being activated. You can change the
chart object's name with this line:

ActiveChart.Parent.Name = "New Name"

but that doesn't change the chart window caption. With he chart window
showing, this changes the window caption:

ActiveWindow.Caption = "New Window Caption"

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Jeff Smith wrote:
I have a control that brings up a graph. The Excel name for the graph shown
in the caption is "Sheet 1 Chart 109".

My question is how can I give the chart a new caption?
and /or
How can I suppress the caption (for other chart objects in the workbook)

I have tried ActiveChart.Caption = "NewTitle" but VBA wouldn't accept this.

Would someone be kind enough to help resolve this.
(I'm very impressed with this News Group - I am learning new techniques,
almost daily)

TIA

regards

Jeff Smith