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
 Batch Plotting with Column Offset - Error Columns

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
jarinfrench Posted - 03/16/2023 : 10:31:06 AM
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?
11   L A T E S T    R E P L I E S    (Newest First)
Timothy Wright Posted - 12/18/2023 : 03:59:15 AM
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
YimingChen Posted - 09/26/2023 : 2:47:17 PM
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.

whalefoil_mo Posted - 09/26/2023 : 10:03:02 AM
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.
jarinfrench Posted - 03/17/2023 : 09:49:09 AM
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.
jarinfrench Posted - 03/17/2023 : 09:46:44 AM
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.
YimingChen Posted - 03/17/2023 : 09:21:40 AM
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.


jarinfrench Posted - 03/16/2023 : 8:24:26 PM
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:
YimingChen Posted - 03/16/2023 : 4:22:59 PM
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?
jarinfrench Posted - 03/16/2023 : 11:59:29 AM
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.
jarinfrench Posted - 03/16/2023 : 11:21:53 AM
I currently have it set up as an X X2 Y2 Yerr Y2 Yerr ... system, screenshot attached.


YimingChen Posted - 03/16/2023 : 11:05:48 AM
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

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