General information
Title:
Excel and chart problem.
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only