thanks for the reply but I am getting "object does not support this property
or method" error

Farooq

"Tom Ogilvy" wrote:

a ChartObject is a container for a chart when it is hosted on a worksheet.
When a chart is on a Chartsheet, there is no ChartObject.

Activesheet.ChartObjects(1).Chart.Name = "Chart 1"

--
Regards,
Tom Ogilvy


"Farooq Sheri" wrote:

I have a workbook that has code for combobox which when executed generates a
chart on one of the sheets. Each time this code is run the chart name, as it
appears on the Chart Window, changes. I want to rename this to "Chart 1". As
a general question what is difference between ChartObject and Charts?

Thanks and regards
Farooq Sheri