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
 Origin Forum
 Link data from different books

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
millot.marius Posted - 11/25/2013 : 8:06:18 PM
Origin Ver. and Service Release (Select Help-->About Origin): 8.5.1
Operating System:win7 64

I d like to fit at once data coming from different worksheets that i want to keep separate.
Each worksheet has a X and a Y column

Can i do a concatenation of a set of columns into one, in a dynamic way (that is that will update automatically when i change the data in the parent worksheet?)

2   L A T E S T    R E P L I E S    (Newest First)
greg Posted - 11/26/2013 : 09:15:44 AM
There is no need for any duplication of data.

Plot all your data in one graph. (The Plot Setup dialog makes this easy.)
After starting the fitter and selecting your Fit Function, go to the Data Selection page and click on the flyout button on the far right of the Input Data.
Choose "Add all plots in active..".
Multi-Data Fit Mode can now be set to Concatenate Fit.
On the Advanced page, set Recalculate to Auto so the fit updates with a change to any of the source datasets.
JessieWoo Posted - 11/26/2013 : 01:06:47 AM
Hi marius,

Please try using the "Set Column Value" to achieve that. You can refer to the link below.
http://www.originlab.com/doc/Tutorials/SetColVal#Using_Columns_from_Other_Sheets

Jessie
OriginLab

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