Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel and chart problem.
Message
De
17/07/2000 14:18:17
 
 
Information générale
Forum:
Visual Basic
Catégorie:
VBA
Divers
Thread ID:
00392708
Message ID:
00393428
Vues:
14
>>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.

I tried it and it didn't work saying that "This object doesn't support this property or method" and underlined the line that tried to set the chart title.

Any other ideas?

Thanks, Steph.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform