Naming charts on own sheet
 

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.

Naming charts on own sheet
 

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.

Naming charts on own sheet
 

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.

Naming charts on own sheet
 

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.