VBA: Can't set ChartTitle.Text??

  • Thread starter Thread starter Ed
  • Start date Start date
E

Ed

My macro tells me it can't set the ChartTitle. "Unable to set the Text
property of the ChartTitle class". Any help. please?
Ed

Sub MakeNewScatterChart()

Dim wkb As Workbook
Dim wks As Worksheet
Dim LastRow As Long
Dim LastCol As Long
Dim colData As Long
Dim cht As Chart
Dim chtObj As ChartObject
Dim rngData As Range
Dim rngXval As Range
Dim rngSer As Range
Dim strTitle As String

' Get limits of data
Set wkb = ActiveWorkbook
Set wks = wkb.Sheets(1)
LastRow = wks.Range("A65536").End(xlUp).Row
LastCol = wks.Range("IV4").End(xlToLeft).Column

' Set data range
Set rngData = wks.Range(Cells(4, 1), Cells(LastRow, LastCol))

' Define X data range
Set rngXval = rngData.Columns(1)

For colData = 2 To LastCol
' Add new chart object
Set cht = wkb.Charts.Add
With cht
.ChartType = xlXYScatterSmoothNoMarkers
' Delete initial data series
Do While .SeriesCollection.Count > 0
.SeriesCollection(1).Delete
Loop

' Add data series
With .SeriesCollection.NewSeries
Set rngSer = rngData.Columns(colData)
.Values = rngSer
.XValues = rngXval
strTitle = wks.Cells(2, colData)
End With

.ChartTitle.Text = strTitle '<<< Error Here
 
Back
Top