The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
 All Forums
 Origin Forum for Programming
 LabTalk Forum
 How to make comparison chart to display two varyin

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
Matrix2021 Posted - 07/15/2020 : 10:52:52 PM
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,

https://drive.google.com/file/d/1mmsL54lWBSVNsrP0INleJe-uW8U-2VVD/view?usp=sharing


https://drive.google.com/file/d/1JigNJKkY2IMGg4-aSXu0NnFnRRuvb6jx/view?usp=sharing

Toppin
4   L A T E S T    R E P L I E S    (Newest First)
Matrix2021 Posted - 07/20/2020 : 3:59:38 PM
quote:
Originally posted by YimingChen

I am sorry that I was talking about running the script in Origin software not in Excel. We have this scripting language called LabTalk which is similar to VBA in Excel. Thanks.


I have realize that I am in the wrong forum. Can you recommend me to someone to help me with my problem?

Thanks in advance

Toppin
YimingChen Posted - 07/20/2020 : 09:36:30 AM
I am sorry that I was talking about running the script in Origin software not in Excel. We have this scripting language called LabTalk which is similar to VBA in Excel. Thanks.

James
Matrix2021 Posted - 07/18/2020 : 02:10:48 AM
Hi YimingChen

I really appreciate your time and effort in responding to me.

However, I am not sure if I followed your tuition to the letter.

I have created a new module copied and paste the script you recommended and made the adjustments. Please view photo below.

My problem here is this: the script is written in red, as it have an error. What do you suggest I do from here? If I have done something wrong, if you are opened in helping me... How can I fix this?

Thanks in advance



Toppin
YimingChen Posted - 07/17/2020 : 4:14:18 PM
Hi Toppin,

A simple script can be:

string strCountry = US; // Set country ( sheet name )
plotxy iy:=[Book1]strCountry$!(1,2) plot:=200 ogl:=[<new template:=LINE12>];  // Plot into graph template LINE12 that is pre-created. 
plotxy iy:=[Book2]strCountry$!(1,2) plot:=200 ogl:=1;
layer -g; //Group plots





James

The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000