VBA: Can't set ChartTitle.Text??

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top