Chart question in Excel 2003

[jeffiec]

Having problems coding a chart. After Activating the chart and trying to give it a tile, I get errors.

Public Sub loadchart()
Worksheets("Main").ChartObjects(1).Activate
With ActiveChart


End With

works with no problem, when I add the following code I get errors,

Public Sub loadchart()
Worksheets("Main").ChartObjects(1).Activate
With ActiveChart
.HasTitle = true

End With

the error is:
Run-time Error '1004' Method 'HasTitle' of object '_Chart' failed

I have tryed almost every example of the help file and on the web, no luck!
HELP!
Thanks in advance.
Jeff

 

[DRJ]

Public Sub loadchart() 

    Worksheets("Main").ChartObjects(1).Activate    
    With ActiveChart
        .HasTitle = True
        .ChartTitle.Characters.Text = "Test"
    End With

So this won't work?

 

[TommyGun]

Try accessing the chart object first.


<font face=Courier New><span style="color:#00007F">With</span> Worksheets("Main").ChartObjects(1).Chart
    .HasTitle = <SPAN style="color:#00007F">True</SPAN>
    .ChartTitle.Text = "Main Chart"
<SPAN style="color:#00007F">End With</span></FONT>

 

[jeffiec]

DRJ, no it doesn't
TommyGun, I get a different error using that code.
"Unable to set the HasTitle property of the Chart class"
Go figure huh?
any other suggestions?

 

[DRJ]

Is the worksheet protected?

 

[jeffiec]

no it is not protected.[/quote]

 

[DRJ]

Can you try to record a macro and see what happens? Tools | Macros | Record Macro

Then manually change the chart title and see what code excel writes for you. Is it different from what has been posted?

 

[jeffiec]

I may have found something, i tryed to recoed the macro, when i right click to change the title of the chart, the Chart optins is greyed and wont let me change it.?

 

[DRJ]

Can you right click and select chart options?

 

[jeffiec]

DRJ, your a genieus!
this worked, thanks for pointing me to record the macro!
ActiveChart.HasTitle = True
ActiveChart.ChartTitle.Text = "testme"
i dont get why, i have not activated the embedded chart, only the sheet?
go figure!