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
 Divide a column in different sections
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

Zisternas

11 Posts

Posted - 06/20/2010 :  1:42:30 PM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Ver. and Service Release (Select Help-->About Origin): origin 8.
Operating System: Win XP

Hi everybody

I would like to ask maybe a dumb question

I have data from an experiment that occupies around 30 columns, but there are just 3 or 4 data rows for each column.

To plot them I have to select the data individually in each column or separate them by sheets. Is there something to subdivide a column in several stages, something like the function "Set as Begin" or "Set as End" but partial (not removing all theother data?)

I don´t know if is clear enough explained, if not just ask!

Thanks in advance!

AmandaLu

439 Posts

Posted - 06/21/2010 :  06:14:27 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Dear Zisternas,

I suppose you want to stack all your 30 columns into 2, and distinguish them by a third column? If so, you can use some LabTalk scripts to stack columns. Below is an example showing you how to stack 2 columns:

http://www.originlab.com/www/helponline/Origin/en/mergedProjects/QuickHelp/QuickHelp/What_is_indexed_versus_raw_data_and_how_to_I_transform_from_one_to_another.html

If this is not what you want, please explain what you want in details.
Go to Top of Page

Zisternas

11 Posts

Posted - 06/23/2010 :  1:22:27 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Thanks AmandaLu, I think this fits what I was searching. Anyway, it doesn´t consider independant the different indexed values? I mean, if I wanted to plot the given example it would plot tireA and tireB as a continous same plot. I was searching for something to do it like this, but I can select the ranges in the plot setup.

Many thanks.
Go to Top of Page

AmandaLu

439 Posts

Posted - 06/25/2010 :  03:55:17 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Dear Zisternas,

It cannot divide column into several ranges according to column values. However, there may be an easy way to plot different ranges of the same column at one time.

Hold down Ctrl key on the keyboard while selecting all ranges you want to plot. Release Ctrl key. Then click Line+Symbol button on the 2D Graphs toolbar.

Go to Top of Page

marlue

1 Posts

Posted - 09/28/2010 :  10:21:09 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Dear AmandaLu,

I also want to plot several data groups from the same column. The trick with Ctrl+mouse already helped me very much.

One furthergoing question: Is there a way to fill the legend with the values from your column A(L) instead of the C-Column name?

Thanks!
Go to Top of Page

AmandaLu

439 Posts

Posted - 09/28/2010 :  10:13:23 PM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Dear marlue,

To fill the legend with the values from a special column instead of Y data column, you can use the substitution notation: %([workbookname]sheetname, column, row[,format]). For example, if you want to use value in column A(L), first row as Legend, you can:

1. Right click on the Legend box and choose Propertie...
2. In the Object Properties dialog that opens, replace %(1) with %([book1]1!,1,1)

Please note that the row in this notation can also support label row characters such as L for longname.

For more information about this notation, please click here.
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