>I'm trying to produce some charts and I keep getting the following error message whenever I try to had a title to my chart:
>
>Method 'HasTitle' of object '_Chart' failed
>
>Here is a sample of my code:
>
>:With ActiveChart
>: .Location Where:=xlLocationAsNewSheet
>: .Type = xlColumn
>: .HasTitle = True
>: .ChartTitle = "Chart for marker #" + conv(num)
>: .SetSourceData PlotBy:=xlColumns, Source:=m_range
>: For colonne = 1 To nb_columns
>: .SeriesCollection(colonne).Name = Sheets("Data").Cells(depart, 2 * colonne + 3).Value
>: Next
>:End With
>
>Am I the simple victim of yet another infamous MS bug or is the problem 10" in front of the screen (again)?
>
>Thanks, Steph.
This is a shot in the dark: Set the title before you say it has one. Maybe it creates a Device context on the fly or for some other reason you cant change it once it 'has' one.
~Joe Johnston USA
"If ye love wealth better than liberty, the tranquility of servitude better than the animated contest of freedom, go home from us in peace. We ask not your counsel or arms. Crouch down and lick the hands which feed you. May your chains set lightly upon you, and may posterity forget that ye were our countrymen."
~Samuel Adams