| T O P I C R E V I E W |
| iphark |
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? |
| 7 L A T E S T R E P L I E S (Newest First) |
| donzeek |
Posted - 03/20/2014 : 7:09:24 PM
quote:
Originally posted by zahraa
Hi Benjamin,
For information on how to patch to the latest SR please visit this page: and specify your version information in the designated dropdown:
http://originlab.com/index.aspx?go=Support/ServiceReleases
However stacking columns is enabled from Origin 8.0 SR6 onwards so you should be able to do so in 8.5 SR1. This tutorial on on stack columns might help you:
http://wiki.originlab.com/~originla/howto/index.php?title=Tutorial:Stack_Column_and_Bar_Charts_of_Rechargeable_Battery_Statistics
If you are still having trouble, you can send your data with details of your desired representation style to tech@originlab.com
Originlab Technical Representative
I had the almost the same problem as him. After spending hours of reading, i was able to fix it. Thanks
|
| baliwebdesign |
Posted - 03/06/2014 : 1:40:39 PM
Maybe you need an SR2 for ordering your column 
|
| iphark |
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!! |
| lkb0221 |
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 |
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 |
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 |
| zahraa |
Posted - 02/11/2014 : 12:28:03 PM
Hi Benjamin,
For information on how to patch to the latest SR please visit this page: and specify your version information in the designated dropdown:
http://originlab.com/index.aspx?go=Support/ServiceReleases
However stacking columns is enabled from Origin 8.0 SR6 onwards so you should be able to do so in 8.5 SR1. This tutorial on on stack columns might help you:
http://wiki.originlab.com/~originla/howto/index.php?title=Tutorial:Stack_Column_and_Bar_Charts_of_Rechargeable_Battery_Statistics
If you are still having trouble, you can send your data with details of your desired representation style to tech@originlab.com
Originlab Technical Representative |
