#1
|
|||
|
|||
How to make comparison chart to display two varying sets of data.
Hello.
I am not sure if you can help me. I just don't know... I would love to know, how to make comparison chart 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 can I create a comparison chart 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 Cheers, Unemployment_Rate.xlsm - Google Drive GDP_Annual_Growth_Rate_%.xlsm - Google Drive |
Tags |
chart series, macro, vba code |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Multiple Column Data Comparison | Croakes92 | Excel | 2 | 07-23-2019 11:59 PM |
Finding sub-sets of data in worksheets | Rudi | Excel | 3 | 01-28-2013 06:13 AM |
Match two sets of data and display specific data | lolly150 | Excel | 1 | 05-14-2012 10:33 PM |
Mail merging and pulling varying data from Excel | shannag1881 | Mail Merge | 0 | 10-05-2009 08:51 AM |
One bar chart for 3 sets of data | rclloyd | Excel | 1 | 02-03-2006 09:51 AM |