Hi, Thanks in advance for your help. I seek your great help on this issue. I have created charts/graphs using SAS EG 7.1. Below the code I was using to create graphs etc. I am using ODS Excel to export the graph to excel. The Graph not copied to excel if I set graph format to "ActiveX/Java" but its being copied to excel If i change the graph format to "JPEG". But the graph is not clear as expected if i use JPEG format. Appreciate if you suggest any other alternate for this. Thanks. libname mylib 'M:\data\sandbox'; ods excel file="M:\Test2.xlsx" ; data anno1; length function style color $8 text $20; retain xsys '5' ysys '5' when 'a' color 'white'; function='move';x=48;y=2.2;line =1;output; function='draw';x=50;y=2.2;line=1;output; function='label';color ='black';x=43.3;y=2.2;position='6';size=.9;text="KS";output; function='move';x=55.5;y=2.2;line =37;output; function='draw';x=57;y=2.2;line=37;output; function='move';color='black';x=38.7;y=1;size=.9;line =1;output; function='symbol';color='white';x=64.5;y=0;position='6';size=3;text="cube";line =0;output; function='label';color ='black';x=55;y=2.2;position='6';size=.9;text="Accuracy Ratio";output; run; goptions cback= white; symbol1 i=hilot v=none c=black h=0 W=0; symbol2 i=none v=cube c=red h=0 w=0 pointlabel=none ; symbol3 i=JOIN h=9pt v=DOT CV=blue CO=blue LINE=1 w=1 CI=blue pointlabel=none; symbol4 i=JOIN h=5pt v=NONE CV=black CO=black LINE=37 w=2 CI=black pointlabel=none; Legend1 LABEL=( FONT='Arial' HEIGHT=8pt JUSTIFY=center " ") VALUE=(FONT='Arial' HEIGHT=8pt "Threshold" " " " " " " ); ; PROC GPLOT DATA=mylib.test ; PLOT BOUND1*calc_poolv AR*calc_poolv KS * calc_poolv tresh*calc_poolv / overlay haxis=axis2 vaxis=axis1 LEGEND=LEGEND1 anno=anno1; ; ;RUN; ods excel close;
... View more