VBA charts work fine in excel 2013 but not in excel 2010

Hello again,

I have charts working fine in Excel 2013 with following code;

With ActiveSheet.ChartObjects.Add(Left:=1, Width:=900, Top:=5, Height:=300).Chart
        .Type = 4
        For Each rngRow In Range("D12:CY12").Rows
            With .SeriesCollection.NewSeries
            .Values = rngRow
            .Name = "='" & rngRow.Parent.Name & "'!" & rngRow.Cells(1, 1).Offset(0, -1).Address(True, True, xlR1C1)
            End With
        Next

.ChartStyle = 250

Consider I have figures in range D12:H12 only. Now I want the chart to be plotted for period ranging from columns D to H only. and this works in excel 2013.

But in excel 2010, this thing plots chart from Column D to Column CY irrespective of the fact the data is only present in range D12:H12.

What thing can be wrong here?

Hello

I just want to replace .....Range("D12:CY12").... with something auto range. So if data is in say, D12:H12 cells, then the chart should automatically select only these cells and not plot all Range("D12:CY12").

Range("D12:CY12") is just the maximum range that this chart must plot.

Thank you

Any solution!!!