Object doesn't support this ......

[VegasNath]

Please, what am I doing wrong here.

[VegasNath]

The chart activates but I get the rte on all three of the following commands.

[HansV]

SetSourceData and SeriesCollection don't apply to a ChartObject (which is basically a shape object) but to the Chart contained in the ChartObject.
You probably don't need to activate the chart to manipulate it, so try

Code: Select all

    With ActiveSheet.ChartObjects("Chart 5").Chart
        .SetSourceData Source:=...
        .SeriesCollection(1).Name = "Blue"
        .SeriesCollection(2).Name = "Red"
    End With

[VegasNath]

Thanks Hans, that worked.