topic Re: Help! Overlapping barlabels in Graphics Programming

Help! Overlapping barlabels

Felix_ — Wed, 12 Jul 2017 13:35:22 GMT

Hi Communitie,

I build now for a couple of hours the necessary data and graphic --> i am almost confident EXCEPT of the overlapping Barlabels (see attached pictures)

The code is following:

PROC SGPLOT DATA= section_1_2;
  VBAR month / RESPONSE= count1 DATALABEL LEGENDLABEL = "Fiscal year &fiscalyear2.";
  VBAR month / RESPONSE= count2 DATALABEL barwidth=0.5 transparency=0.4  LEGENDLABEL = "Fiscal year &fiscalyear1.";
  YAXIS VALUES= &yaxis OFFSETMIN= 0 LABEL= "Number of Follow-ups";
  XAXIS LABEL= "Month" DISCRETEORDER=DATA ;
RUN;

I did previously some GTL stuff for other projects....but i dont have an idea how to solve this overlapping problem.

...Maybe i am lacking of creativity --> does someone has a solution?

Best regards & thanks in advance,

Felix S.

Re: Help! Overlapping barlabels

Jay54 — Wed, 12 Jul 2017 16:04:32 GMT

Well, you have two bars with bar labels. So, if the values are close, the labels will overlap. There are multiple solutions:

If your data is presummarized (does not have multiple observations for same month), you could move one of the labels to the bottom of the bar. If you have SAS 9.40M3, use VBARPARM to display the summarized bars, and overlay a TEXT plot to display the label at the bottom (y=0). If earlier version, use SCATTER with MARKERCHAR. Just create a variable y=0 in the data and use that with the scatter or text plot. Use appropriate color.

Or, you can use a XAXISTABLE to put both bar values under the bars.

Re: Help! Overlapping barlabels

Felix_ — Tue, 18 Jul 2017 13:43:04 GMT

Hello Sanjay,
Thank you for your quick Response and suggestions. I will try the Options soon !