Change chart attribute when chart is grouped

Hi,

Is there a way via VBA to change the color of SeriesCollection(1) when the chart (named "Chart01") it resides in is part of a grouped collection of shapes and charts named "Group01" on Sheet2?

Thanks,

Lawrence

try this:

Sub change_colour()
Sheets("Sheet2").Shapes("Group01).GroupItems("Chart01").Chart.SeriesCollection(1).Format.Line.ForeColor.RGB = RGB(255, 0, 0)
End Sub