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
 Batch Plotting with Column Offset - Error Columns
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

jarinfrench

USA
6 Posts

Posted - 03/16/2023 :  10:31:06 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Ver. and Service Release (Select Help-->About Origin): 2021b (64-bit) SR2
Operating System: Windows 10

I have a fairly large dataset that consists of an X column followed by a series of Y and Yerr columns. I have generated one plot with the Y and Yerr as desired, but when I use the Duplicate (Batch Plotting) option with Column Offset the error columns do not shift with the Y column, irrespective of whether or not the "Use Associated X&E" checkbox is marked. Is there a simple option that I am missing that would allow me to batch plot the data with the correctly associated Yerr columns?

YimingChen

1651 Posts

Posted - 03/16/2023 :  11:05:48 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Is the column designation of the worksheet X,Y,Yerr,Y,Yerr,...? If so, then duplicating the graph with "Use Associated X&E" checked should work. Could you attach a screenshot of the worksheet, or share your project file? Thank you.

James
Go to Top of Page

jarinfrench

USA
6 Posts

Posted - 03/16/2023 :  11:21:53 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
I currently have it set up as an X X2 Y2 Yerr Y2 Yerr ... system, screenshot attached.


Go to Top of Page

jarinfrench

USA
6 Posts

Posted - 03/16/2023 :  11:59:29 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Here's some further information as I've played around with things.
If the original plot only uses columns from a single worksheet, the associated error columns are correctly assigned, but if I am plotting from multiple worksheets, it seems the error columns are fixed to what the original columns are.

Edited by - jarinfrench on 03/16/2023 12:00:00 PM
Go to Top of Page

YimingChen

1651 Posts

Posted - 03/16/2023 :  4:22:59 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Are you saying for your original plot the y column is from one sheet and the error column is from another, which causes the issue?
Go to Top of Page

jarinfrench

USA
6 Posts

Posted - 03/16/2023 :  8:24:26 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
No, rather what happens is the Yerr column that was selected in the original graph is used for all of the batch plotted graphs. I have attached a few screenshots of what this looks like, vs what I expect.

Original plot:


Expected plot:


Actual plot:
Go to Top of Page

YimingChen

1651 Posts

Posted - 03/17/2023 :  09:21:40 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
I still couldn't reproduce the issue. I plotted col(C) as Y and col(D) as Yerr from three workbooks, then duplicate the graph with col(E) with the following settings. Then col(F) is properly set as the Yerr column. Can you double-check if the settings are the same as below.


Go to Top of Page

jarinfrench

USA
6 Posts

Posted - 03/17/2023 :  09:46:44 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
I've generated an example project that demonstrates the issue.
https://my.originlab.com/ftp/forum_and_kbase/Images/ExampleBatchPlotErrorBarIssue.opju

The "Original" graph uses the 1st and second column from Book1, Book2, and Book3. The "BatchPlotDuplicate" plot is the result of right-clicking on "Original" --> Duplicate (Batch Plotting), and using the options indicated in the screenshot.


Checking the plot setup of the "BatchPlotDuplicate" figure shows the results below:


While the expected result is plotted in "ExpectedBatchPlotDuplicate", with the below x,y, and yerr.
Go to Top of Page

jarinfrench

USA
6 Posts

Posted - 03/17/2023 :  09:49:09 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
I realized when I sent this that I had not correctly designated the columns, and doing so in the example project results in the correct result. However, the columns in my original dataset are correctly set, but the issue still remains.

It seems likely that this is a user error, so I'll play around with things to figure it out. Thanks for the assistance.

Edited by - jarinfrench on 03/17/2023 09:54:02 AM
Go to Top of Page

whalefoil_mo

United Kingdom
1 Posts

Posted - 09/26/2023 :  10:03:02 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Just a heads-up, I'm experiencing the exact same problem you've described here. So unless we're both doing something wrong, I believe that it is a software issue within Origin.
Go to Top of Page

YimingChen

1651 Posts

Posted - 09/26/2023 :  2:47:17 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
I'm not entirely certain about the issue you encountered. For the original post, it appears that the user simply needs to assign the Y error column to resolve the issue.

James

quote:
Originally posted by whalefoil_mo

Just a heads-up, I'm experiencing the exact same problem you've described here. So unless we're both doing something wrong, I believe that it is a software issue within Origin.

Go to Top of Page

Timothy Wright

Australia
1 Posts

Posted - 12/18/2023 :  03:59:15 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
EDIT: While typing this out, I identified the culprit, I haven't figured out how to correct for the issue, so I'll keep the rest of my post in. The graph that I am batch plotting includes a second group, that is based upon a different sheet (one's initial readings, one's after treatment). They are both set-up identically, the numbers are just different. If I include both groups in the graph that I am duplicating from, the error bar is not offset for either group. When I delete either of the groups, the error bar functions again. Haven't been able to find a workaround, but if I do I'll add another post


I'm also experiencing this issue. While it may have been the case that the OP improperly used column designations in their test dataset, they also mentioned that the designations were the same as their actual data set.

So while the issue may be caused by a misunderstanding of column designations, I can't figure out how I'm misusing them.

My current dataset is set-up as X-Y-Yerr-Y-Yerr-etc

As fair as I understand the page on column designations https://www.originlab.com/doc/en/Origin-Help/WksCol-SetDesignation. This should work
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