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 for Programming
 LabTalk Forum
 Color Scale Control - Formula
 New Topic  Reply to Topic
 Printer Friendly
Author  Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

ajsauter

1 Posts

Posted - 12/16/2025 :  12:08:57 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Ver. and Service Release (Select Help-->About Origin): OriginPro 2026 (Learning Edition)
Operating System: Windows 11

I have created a 3D-Surface stacked plot with three unique color maps. The stacked plot requires input data that "stacks" the previous column's values with the existing column's data. I am attempting to remove the previous column's offset from each individual color map label, with the following formula:

round((x-[Book1]"Sheet1"!col(H)[i])/1000)

The division is there to place the proper units, and the "round()" function keeps the data clean.

However, the x-value is subtracted by the maximum value in col(H), not the specific row called out via "[i]". Has anyone else run into this, and is there a simple fix that I am missing? I am new to the LabTalk programming language. I have attempted, for example, to only take the minimum value from col(H) via:

round((x-[Book1]"Sheet1"!min(col(H)))/1000)

This produces the intended output, but does not provide me with the solution I need.
   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