Hi Helpers,
I create a chart that use StatterSmoothNoMarkers type. The xvalue is fixed @ location A2: A100.
But the Series value is depended on number of files opened. If they open 3 files, i have 3*3=9 columns data and so on. I got the code from online and modified it for my case. I dont know how to put all collected data together to make them become data source. Could you please help me out.
Thanks. Here is the line with the error:
Set rngChtData = ("A2:A100") , ("2"): intCol5.Select ------->error right here

Please Login or Register  to view this content.