Hi,
I've been working on an excell script that get every week different CSV files, imports them to excel, and creating charts for each sheet.
Creating a first time Chart is working like a charm:
Please Login or Register to view this content.
However, whenever I try to update the SetSourceData for an existing chart, I get wrong range and wrong chart's data. The updating macro is:
Which is exactly the same as creating the chart.Please Login or Register to view this content.
I would appreciate any help.
Thx ^_^
Bookmarks