G
Guest
I have a macro that creates a Line Column on 2 Axes Chart and holds 3 sets of
data, the first 2 represented by columns, the third by a line. I have been
unsuccessfully trying to get the line to smooth between data points.
I have tried code such as:
With ActiveChart.LineGroups(1)
.Smooth = True
End With
Which gives me the error: "Object doesn't support this property or method"
or:
Dim Ser As Series
Set Ser = Charts("Attendance Roster Chart").SeriesCollection("Attendance
Pivot")
With Ser
.Smooth = True
.Border.Weight = xlThick
End With
(The chart name sheet is "Attendance Roster Chart", and the series is
"Attendance Pivot")
Which gives me the error message "Unable to get the SeriesCollection
property of the chart class"
I'm getting frustrated. Any ideas?
Thanks in advance
data, the first 2 represented by columns, the third by a line. I have been
unsuccessfully trying to get the line to smooth between data points.
I have tried code such as:
With ActiveChart.LineGroups(1)
.Smooth = True
End With
Which gives me the error: "Object doesn't support this property or method"
or:
Dim Ser As Series
Set Ser = Charts("Attendance Roster Chart").SeriesCollection("Attendance
Pivot")
With Ser
.Smooth = True
.Border.Weight = xlThick
End With
(The chart name sheet is "Attendance Roster Chart", and the series is
"Attendance Pivot")
Which gives me the error message "Unable to get the SeriesCollection
property of the chart class"
I'm getting frustrated. Any ideas?
Thanks in advance