topic Re: Add in Graphics Programming

Add space between bars

Dreamer — Wed, 28 Jan 2015 21:57:40 GMT

Hi,

In below graph you can see number labels are so congested. Also if number of digits gets more than 4 then it doesn't display at all.

I was wondering if there is a way to fix this. Can we increase space between bars?

Re: Add

ballardw — Wed, 28 Jan 2015 22:13:53 GMT

Code used to create the graph as the procedure, the output destination (HTML, RTF, PDF or other) AND which SAS version you are running has bearing on solutions.

Re: Add

Dreamer — Thu, 29 Jan 2015 15:59:45 GMT

I'm creating Excel output by running following code in SAS 9.4:

options device=ACTXIMG nobyline;

goptions device=png rotate=landscape ;

ods graphics on;

ods excel

options(sheet_interval='none' sheet_name='Graph Output' sheet_label=' ' suppress_bylines='yes'

orientation='landscape' embedded_titles='yes' center_horizontal='yes'

embedded_footnotes='yes')

style=minimal ;

PATTERN1 COLOR=CX1F497D;

Axis1 STYLE=1 WIDTH=1 MINOR=(NUMBER=1) LABEL=(f="calibri/Bold" "Group Counts" ) value=(h=8pt) ;

Axis2 STYLE=1 WIDTH=1 LABEL=( f="calibri/Bold" "Enrollment Date CCYYMM" )value=(h=8pt);

TITLE underlin=2 "#byval(region)";

FOOTNOTE;

PROC GCHART DATA=REGIONGRPCNT ;

BY region;

VBAR ccyy /width=5 SUMVAR=grpcnt CLIPREF FRAME DISCRETE TYPE=SUM space=3

SUM

COUTLINE=GRAY

RAXIS=AXIS1

MAXIS=AXIS2

LREF=1

CREF=GRAY

AUTOREF ;

RUN;

ods excel close;

Re: Add

ballardw — Thu, 29 Jan 2015 18:32:02 GMT

Sorry, I can't help much as I don't have 9.4 and our IT won't let us generate activex anything. If fitting on a printed page isn't quite an issue then increasing the setting of HSIZE in the goptions statement might help.

Re: Add

GraphGuy — Mon, 21 Sep 2015 15:09:39 GMT

You would need to make the graph itself wider, in order for the bars to be wider.

I'm not sure about activex, but with device=png, you can use 'goptions xpixels=1000;'

Once the page is wider, the gchart bars typically auto-size to fill up a 'comfortable' amount of the space, but you can further refine/control the bar width using the width= option.

Here's a small example:

goptions device=png xpixels=1000;

proc gchart data=sashelp.electric;
vbar year / discrete type=sum sumvar=revenue outside=sum width=8;
run;