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