A:=INTPART((C/REF(C,1)*100-100)*100+0.5)/100; B1:=IF(A>=4 AND A<6,1,0); B2:=IF(A>=6 AND A<8,2,0); B3:=IF(A>=8 AND A<9.5,3,0); B4:=IF(A>=9.5,4,0); STICKLINE(B1>0,C,O,3,0),COLORYELLOW; STICKLINE(B2>0,ABS(C-O)/2+MIN(C,O),MIN(C,O),3,0),COLORYELLOW;{满足4%-5.99%画黄色} STICKLINE(B2>0,ABS(C-O)/2+MIN(C,O),MAX(C,O),3,0),COLORLIMAGENTA;{满足6%-7.99%画淡粉色} STICKLINE(B3>0,ABS(C-O)/3+MIN(C,O),MIN(C,O),3,0),COLORYELLOW; STICKLINE(B3>0,ABS(C-O)/3+MIN(C,O),ABS(C-O)/3*2+MIN(C,O),3,0),COLORLIMAGENTA; STICKLINE(B3>0,ABS(C-O)/3*2+MIN(C,O),MAX(C,O),3,0),COLORRED; STICKLINE(B4>0,ABS(C-O)/4+MIN(C,O),MIN(C,O),3,0),COLORYELLOW; STICKLINE(B4>0,ABS(C-O)/4+MIN(C,O),ABS(C-O)/4*2+MIN(C,O),3,0),COLORLIMAGENTA; STICKLINE(B4>0,ABS(C-O)/4*2+MIN(C,O),ABS(C-O)/4*3+MIN(C,O),3,0),COLORRED; STICKLINE(B4>0,ABS(C-O)/4*3+MIN(C,O),MAX(C,O),3,0),COLORMAGENTA; 复制代码 |