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
Username:
 Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum
 Origin Forum
 Link data from different books		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

millot.marius

USA
38 Posts
Posted - 11/25/2013 :  8:06:18 PM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
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?)

JessieWoo

China
46 Posts
Posted - 11/26/2013 :  01:06:47 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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
Go to Top of Page

greg

USA
1378 Posts
Posted - 11/26/2013 :  09:15:44 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
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.
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000