All Forums  Origin Forum for Programming  LabTalk Forum  Color Scale Control - Formula

Note: Only the poster of this message, and the Moderator can edit the message.

Screensize: 640 x 480 800 x 600 1024 x 768 1280 x 1024 UserName: Password: Anti-Spam Code: Format Mode: Basic  Help  Prompt  Format: Font Andale Mono Arial Arial Black Book Antiqua Century Gothic Comic Sans MS Courier New Georgia Impact Lucida Console Script MT Bold Stencil Tahoma Times New Roman Trebuchet MS Verdana   Size 1 2 3 4 5 6   Color Black Red Yellow Pink Green Orange Purple Blue Beige Brown Teal Navy Maroon LimeGreen Forum: LabTalk Forum Subject: Message: * HTML is OFF * Forum Code is ON Smilies 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.   Check here to subscribe to this topic.