Matrix2021
New Member
Hello.
I am not sure if you can help me. I just don't know...
I would love to know, how to make combination chart in excel to display two varying sets of data.
I have two workbooks.
One of the workbook have 181 worksheets. "Each worksheet name after a country and have its own data.
Next
The other workbook have 185 worksheets."Each worksheet name after a country and have its own data.
This is the hard part:
#1 How can I link both workbook data together using macros? Country vs Country or USA vs USA as an example.
#2 How to make combination chart in excel to display two varying sets of data, both varying sets of data beginning with the zero values?
If you think I sound crazy. Please just say so lol. I am not sure if you are open in helping me. If so, I am looking for someone to point me to the right direction.
Thanks in advance
drive.google.com
drive.google.com
I am not sure if you can help me. I just don't know...
I would love to know, how to make combination chart in excel to display two varying sets of data.
I have two workbooks.
One of the workbook have 181 worksheets. "Each worksheet name after a country and have its own data.
Next
The other workbook have 185 worksheets."Each worksheet name after a country and have its own data.
This is the hard part:
#1 How can I link both workbook data together using macros? Country vs Country or USA vs USA as an example.
#2 How to make combination chart in excel to display two varying sets of data, both varying sets of data beginning with the zero values?
If you think I sound crazy. Please just say so lol. I am not sure if you are open in helping me. If so, I am looking for someone to point me to the right direction.
Thanks in advance
Unemployment_Rate.xlsm
drive.google.com
GDP_Annual_Growth_Rate_%.xlsm
drive.google.com