b

It's sad to see that you rather delete your question than do the right thing. This community helps people like you. You can do your part and help it, too. 

Hello,

if you post the same question on multiple forums, please post links to all your questions, so that people don't waste their time solving a problem that may already have an answer somewhere else.

This is the link to your post on Stackoverflow, and the answer I gave you there. 

The data for a chart needs to be in a worksheet somewhere. You are looping through several workbooks and with each iteration of the loop you are changing the data source for the SAME series in the chart.

If you want to create a chart with multiple series from multiple workbooks, that approach will never fly.

The chart will need to have a separate data source for each series. You may want to copy the data for each series to the workbook that hosts the chart, then add each new series to the chart as the data is coming in to the workbook.

I'm not even trying to give you code for that. You need to re-think your approach and understand how a chart and the underlying data works. Then you can write code to populate the data source for your chart.