All Forums  Origin Forum  Origin Forum  inserting arrows using script

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

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 Message: * HTML is OFF * Forum Code is ON Smilies [quote][i]Originally posted by zknauss[/i] [br]Good afternoon, I have the below script which I'm using to sort data based on pattern of change. Currently its operating how I intended but instead of outputting letters I'd like it to output Arrows representing the direction of change specifically what I'd like to have it output is below: A = up arrow, color (red), shortcut key code: 2191 B = horrizontal bar, color (black), code: 2015 C = down arrow, color (blue), code: 2193 Thanks in advance for any help with this for (int i = 1; i <= wks.ncols; i++ ){ range aa = [NCONFreReg]"Frequency_T1"!$(i+1); range bb = [NCONFreReg]"Frequency_T2"!$(i+1); %j=wcol(i)[1]$; wcol(i)[2]$ = if(bb[1]>0.01&&bb[1]>=aa[1]&&bb[2]<=aa[8],"A", if(bb[1]>0.01&&bb[1]>=aa[1]&&aa[8]==0&&bb[2]!=0,"A", if(bb[1]>0.01&&bb[2]>aa[8] && bb[2]<aa[9] && %j!="B","B", if(bb[1]>0.01&&bb[1]<aa[1] && bb[2]>aa[9] && %j!="B","C","I")$)$)$)$; } ZTK [/quote]   Check here to include your profile signature. Check here to subscribe to this topic.