Out of Memory error when trying to name a chart. How do I name a chart in vba?

[OaklandJim]

Here are relevant portions of code:

    Dim wsData As Worksheet

    Dim cResults As Chart

    Set wsData = ThisWorkbook.Worksheets("Sheet1") '<= worksheet containing data

    Set cResults = wsData.Shapes.AddChart.Chart
    
    With cResults
'
        .ChartType = xlBarClustered

         .SeriesCollection.Add Source:=rDataSeries

'       This causes an out of memory error.
        .Name = "ECR Counts"

    End With

The .Name part gives me Run-time Error 7: Out of Memory. How do I name a chart in vba?

 

[KOKOSEK]

try:

.Parent.Name = "ECR Counts"

 

[OaklandJim]

Thanks Kokosec

I'm doing my first char by VBA and it is not so straightforward. I appreciate the assistance!

Might you be able to tell me how to delete an existing version of the chart.

I Tried
wsData.Charts("ECR Counts").Parent.Delete

wsData.Shapes("ECR Counts").Parent.Delete

 

[OaklandJim]

Got it

wsData.ChartObjects("ECR Counts").Delete