Forum Discussion
Plotting Excel data from several workbooks together automatically.
Hey Jamiu-
Here's a basic beginners guide that may help:
https://www.ablebits.com/office-addins-blog/2013/12/06/add-run-vba-macro-excel/
You'll need to modify the code to fit your needs for it to work. In addition I didn't understand if the charts already existed in your workbooks or whether you wanted to make new ones. Depending on your answer, the code could vary.
DISCLAIMER: VBA IS ALMOST ALWAYS IRREVERSIBLE. SO MAKE SURE YOU HAVE COPIES OF YOUR FILES.
- 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.- 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.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/