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;

Please Login or Register  to view this content.

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!!!