Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-15-2020, 07:04 PM
Matrix2021 Matrix2021 is offline How to make comparison chart to display two varying sets of data. Windows 10 How to make comparison chart to display two varying sets of data. Office 2019
Novice
How to make comparison chart to display two varying sets of data.
 
Join Date: Jul 2020
Posts: 1
Matrix2021 is on a distinguished road
Default 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
Reply With Quote
Reply

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
How to make comparison chart to display two varying sets of data. One bar chart for 3 sets of data rclloyd Excel 1 02-03-2006 09:51 AM

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 02:36 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft