| Author |
 Topic  |
|
|
iphark
12 Posts |
 Posted - 02/11/2014 : 05:48:45 AM
|
Origin Ver. and Service Release (Select Help-->About Origin): Origin 8.50G SR1
Operating System:Win7
Hello,
I did an electrolysis for an hour and instead of measuring just the hour I measured every minute giving me 60 columns for each parameter. Now I'd like to stack the columns in order to draw a graph of the whole experiment. And it should be easy. Worksheet menu - stacking columns. Well, I can split columns but there is no option to stack them.
Can someone help me?
greetings
iphark
Edit: Ok, I just saw I'd need SR2 in order to stack columns. Now, as I am completely new to Origin - does that mean I just need to update or is it upgrading? |
Edited by - iphark on 02/11/2014 05:51:43 AM |
|
|
zahraa
USA
52 Posts |
|
|
lkb0221
China
497 Posts |
Posted - 02/11/2014 : 3:22:35 PM
|
Hi,
Do you mean your data is all in the same row? with 60*60=3600 columns?
Zheng |
Edited by - lkb0221 on 02/11/2014 5:08:03 PM |
 |
|
|
iphark
12 Posts |
Posted - 02/20/2014 : 01:05:05 AM
|
Hi,
I'm sorry, I have been in vacation for the last week so I could not answer. I may not have been clear enough as english is only my second language.
I am not trying to create a "stacked bar graph". I am not trying to make a graph in the beginning.
I have 60 columns. Each of those columns has 24000 rows. Lets call the columns 1, 2, 3 ... 60. What I would like to have is just one column, containing the values of those 60 columns on top of each other, like this:
1
2
3
4
5
6
But thank you for the time you took to answer me! |
|
|
|
lkb0221
China
497 Posts |
Posted - 02/20/2014 : 10:12:56 AM
|
Hi,
Please try the following script.
//Start
//Assume your 60 columns are in the first sheet of that workbook.
int size = 24000; // The number of rows in each column
int colnum = 60; // The number of columns
%Z = %H; // Remember the source book name
string nbk$;
newbook result:=nbk$; // Create a new book for result
loop(ii,1,colnum) // Looping over all columns
{
range rr1 = [%Z]1!col($(ii))[1:$(size)];
range rr2 = [nbk$]1!col(2)[$(1+size*(ii-1)):$(size*ii)];
rr2 = rr1;
}
//End
Besides, "Stack Columns" tool is added in Origin 8.5.1.
We highly recommend you to try our newest leased version Orign9.1, which is much more powerful than 8.5
http://www.originlab.com/index.aspx?go=DOWNLOADS/OriginEvaluation
Zheng
OriginLab |
|
|
|
iphark
12 Posts |
Posted - 02/28/2014 : 01:13:59 AM
|
| Thank you for your help, I solved the problem by changing the experiment, now I get all my data in one column. But thank you anyway!! |
|
|
|
baliwebdesign
Indonesia
1 Posts |
Posted - 03/06/2014 : 1:40:39 PM
|
Maybe you need an SR2 for ordering your column 
|
|
|
|
donzeek
USA
1 Posts |
|
| |
Topic |
|
I can't stack columns