Forum Discussion
Plotting Excel data from several workbooks together automatically.
Hello Please, I have about 60 excel workbooks in a folder. With the same data structure. I need to create another excel workbook that automatically plot "a certain column data" in each of the 60 exce...
Thank you Matt. But seems I am still battling with it.
The challenge is:
1: I have like 60 excel files in a folder
2: I created another excel file specifically to plot all the data in each of the excel files inside the folder together.
3: What I need to do is to create a vba code for the chart that pulls specific data from each of the 60 excel files in the folder and plot them together automatically.
Please kindly help with this. Thanks.
The challenge is:
1: I have like 60 excel files in a folder
2: I created another excel file specifically to plot all the data in each of the excel files inside the folder together.
3: What I need to do is to create a vba code for the chart that pulls specific data from each of the 60 excel files in the folder and plot them together automatically.
Please kindly help with this. Thanks.
Can you tell me where the data is in each of the 60 workbooks? It sounds like you need to iterate through the files and pull the data out of them into a master file and then plot them all in a single graph based on the consolidated data in the master file....
It may be easier to use Power Query than VBA. It just depends on the scenario:
https://www.myexcelonline.com/blog/consolidate-multiple-excel-workbooks-using-power-query/
https://www.excel-university.com/retrieve-values-from-many-workbooks/
Thank you Matt. The data is in Column AX and AY - From Row 4 to Row 45 for each of the 60 excel files. I want to make Column AX the y-axis and Column AY the x-axis and plot them.
Yes, it seems that's what i want to do.