Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excel and chart problem.
Message
From
14/07/2000 17:19:11
 
 
To
All
General information
Forum:
Visual Basic
Category:
VBA
Title:
Excel and chart problem.
Miscellaneous
Thread ID:
00392708
Message ID:
00392708
Views:
47
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.
Next
Reply
Map
View

Click here to load this message in the networking platform