| T O P I C R E V I E W |
| Alla Goncharenko |
Posted - 10/29/2020 : 07:07:20 AM
Origin Ver. and Service Release (Select Help-->About Origin): 2020 9.7.0
Operating System: windows 10
I am having a trouble to figure out how to shift MULTIPLE curves on one graph to 0 point on the y-axis at a time. I can apply "curve translate" for an individual curve and shift it to "0" using an anchor index "1". Though, I have many graphs with 90 curves on every of them. Is there a way to move all the curves at once? |
| 2 L A T E S T R E P L I E S (Newest First) |
| snowli |
Posted - 10/30/2020 : 5:28:52 PM
Hello,
Where are the data located.
If you have them in same worksheet, you can enter this formula in F(x) cell of the column
This-This[1]
It will subtract the column with 1st value in the column.
u can drag bottom-right corner of the F(x) cell and drag it to all such column to the right so all such columns will do such subtraction.
Thanks, Snow |
| aplotnikov |
Posted - 10/30/2020 : 03:34:57 AM
Hello,
If you need to shift your curves by their minimum value, I would suggest a short Labtalk script:
loop(iCol, ...) {
col(iCol)=col(iCol)-min(col(iCol));
}
You need to point the start and the end columns in the loop() statement for each worksheet (you can loop over workbooks/-sheets using "doc -e(f)" command). if you have multiple XY-data, you may need to use the for()-statement or to calculate column index within the loop()-statement.
Or you have to describe your task more precisely - at least, the criterium to calculate the shift for each dataset.
Regards,
Alexei |
|
|
