Naming charts on own sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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??
 
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
 
Back
Top