Hi there,

I have a template.xlsx with Sheet1 being the DataSource and Sheet2 being the Chart object for it. I'm using example in the following link (but my code is in VB):

http://msdn.microsoft.com/en-us/library/dd452407.aspx

Everything is ok except for the part where I need to re-define the DataSource range. In the example in above link, the method FixChartData is supposed to be what I need. But I'm getting this error:

"Sequence Contains No Element".

Could you please help?

Thanks a lot! Much appreciated!