You can access both types using the following style of code.

' chart sheet
With ActiveWorkbook.Charts("Chart1")
.HasTitle = True
.ChartTitle.Text = "Chart Sheet"
End With

' worksheet chart object
With ActiveWorkbook.Worksheets("Sheet1")
With .ChartObjects("Chart 1").Chart
.HasTitle = True
.ChartTitle.Text = "Chart Object"
End With
End With

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"BoRed79" wrote in message
...
Will the chart sheets be able to be used in a Macro (by referring to the
sheet tab name) or would they need to be chart objects, so that they can
be
named??


"Andy Pope" wrote:

Hi,

If you have chart sheets you can change the name by simply changing the
sheet tab name.

What you described is the method used on chartobjects, which are usually
on
a worksheet.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"BoRed79" wrote in message
...
Hi.

I have a series of charts (which are all contained on their own
sheets).

I need to name each of the charts (as they will be used by someone else
in
a
macro).

I have tried clicking on them and also pressing shift before clicking
on
them, and I am not able to change the name in the name combo box.

Can anyone advise me of how I can change the names.

Thanks for your help.