SAS 'tips' on ODS Excel/Y axis labeling with breaks in Y axis

[LB]

So I have two things I am trying to solve- 

1) I am using vbarparm. Some of the stack bars have very small numbers and so there is no room for numbers.  I am attempting to use tips in an ODS excel document-Is this even feasible?  Or does it have to be pdf?  

2) Due to the y axis range statement, the y axis labeling seems inoperable. Code and diagram below. Facilities have been deleted. 

Thank you.

Lawrence

proc sgplot data=ID_w4g dattrmap=attrmapxe ;

styleattrs DATACONTRASTCOLORS=(black);

vbarparm category=facid response=numx/group=type grouporder=data dataskin=pressed attrid=MYIDXE TIP=(type) tipformat=(auto)
groupdisplay=stack ;

YAXIS LABEL = "ABC" ;
XAXIS LABEL = " " ;
keylegend /title=' ';
yaxis ranges=(0-175 1100-1300);
run;

 

[ballardw]

If you have multiple YAXIS statements I think only the last one gets used.

Try a single statement:

yaxis ranges=(0-175 1100-1300)   LABEL = "ABC"  ;

How are you sending the results to Excel?

[LB]

I had incidentally figured out the label part-

For excel-just using an ODS destination

ods excel file="/apps/sas/datasets/data137/NCQOS/dev/nc_qos_sandbox/data/cdiff/xxx.xlsx" style=Seaside options(sheet_name="XXX" SHEET_INTERVAL= 'PAGE' autofilter='NO' FROZEN_ROWHEADERS='no'
embedded_titles='yes' embedded_footnotes='yes' embed_titles_once = 'on'
embedded_titles='on'
gridlines='off' START_AT='3,3');

proc report; 

etc etc 

LB