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?