T O P I C R E V I E W |
aagar001 |
Posted - 06/09/2007 : 2:01:14 PM Hey there every1, i am Using Windows Xp and i have a problem. I have a text file that is formatted in single coulmns and i need to be able to graph it. I know origin can take that single column data and put it into two columns so you then can use excel or matlab and graph it. Any ideas of how this can be done. |
4 L A T E S T R E P L I E S (Newest First) |
aagar001 |
Posted - 06/13/2007 : 03:19:12 AM thanks for all the help. I actually figured out the problem. The data that i had had data for 6 different graphs so i had to split it all apart into separate columns and once i did that it was easy to obtain my plots. |
Mike Buess |
Posted - 06/10/2007 : 7:58:23 PM I know nothing about the Agilent 4155c but first you asked how to put one column into two in order to graph the data. Perhaps the data are correct as they are, i.e., all in one column. First select the column, then Column> Set As Y and then pick a style on the Plot> menu.
Mike Buess Origin WebRing Member |
aagar001 |
Posted - 06/10/2007 : 5:50:17 PM okay i am not sure if that was the answer i was looking for. So let me explain this, in class we used the Agilent 4155C Semiconductor Parameter Analyzer and when we used it, we obtained some graphs but when we tried saving the graphs the only thing it saved was a text file that contains the data for the graph. With this data how do i go about graphing it so i can see the graph that i saw on the Agilent 4155c |
Mike Buess |
Posted - 06/09/2007 : 4:04:45 PM Depends on how the column is arranged but these solutions cover the only possibilities I know about.
1> Use this script to copy the 2nd half of the column to the column 2...
if( wks.ncols==1 ) wks.AddCol(); // add column if necessary get col(1) -e npt; // number of rows nn=npt/2; copy -b (nn+1) col(1) col(2) -b 1 -e nn; // copy 2nd half to col2 set %H -er nn; // reduce number of rows by half
2> Use this to copy even rows to column 2 and keep the odd rows in column 1...
if( wks.ncols==1 ) wks.AddCol(); get col(1) -e npt; temp = col(1); copy -u temp col(1) col(2); set %H -er npt/2; del temp;
Mike Buess Origin WebRing Member |