Question on setting names and values of SeriesCollection

[mchow2469]

Hi,

Right now I get a runtime error when modifying my chart through VBA:
Unable to set name property of Series Class.

Here is the code that causes it:

With mychart        
        'plot average
        .SeriesCollection(6).Name = "=""Average"""
        .SeriesCollection(6).Values = "=CSS!R10C" & avgCol & ":R54C" & avgCol
    End With

The name and values of the series collection of my chart is already defined before this code is ran ( by right click chart |source data option).
Is it possible to change the name and values again in VBA? Because this is exactly what I am trying to do, which is causing the run time error.

If it is not possible to change the name and values of the series collection again, then how would I work around this issue? Thanks!