Hi,

I have created a horizontal stacked bar graph for which the X-axis labels are not being displayed in full, their few parts of texts are not being visible. I do not want to increase the size of frame but need to display the X-axis labels in full.

I have applied few codes like:
setO1LabelStagger(true);
setO1LabelWrap(true);
setO1LabelAutofit(true); but it is not working for me.

Could anybody please advise?
Thanks,
Keshav

This message has been edited. Last edited by: <Emily McAllister>,

Shrink the font sizes of the labels?

It would be helpful it you showed your code.

Better yet: Duplicate your issue with an IB Sample file so that we can analyze it and provide you with a solution.

Below is the entire code being used:-


-SET &ECHO = ALL;
-SET &CUSTOMER_KEY=&CUSTOMER_KEY;
-SET &CLOSEOUT_DATE=&CLOSEOUT_DATE;
-SET &REPORT_TYPE='Timeline';

TABLE FILE QBRREPORTDATA
PRINT
*
WHERE CUSTOMER_KEY EQ &CUSTOMER_KEY
WHERE REPORT_TYPE EQ '&REPORT_TYPE.EVAL'
WHERE END_DATE_CLOSEOUT EQ '&CLOSEOUT_DATE.EVAL'
ON TABLE HOLD AS PSQLOUT
END

DEFINE FILE PSQLOUT
CATEGORY_FMT/A3 =SUBSTR(1000,CATEGORY,1,3,3,'A3');
CATEGORY_NAME/A100 = IF CATEGORY_FMT EQ '004' THEN 'AVERAGE NUMBER OF DAYS FROM INVOICE DATE TO RECEIPT DATE' ELSE IF CATEGORY_FMT EQ '005' THEN 'AVERAGE NUMBER OF DAYS FROM INVOICE DATE TO PAYMENT DATE' ELSE IF CATEGORY_FMT EQ '006' THEN 'AVERAGE NUMBER OF DAYS FROM RECEIPT DATE TO CLOSE DATE' ELSE '';
SORT/A5= DECODE CATEGORY_FMT(004 '1' 005 '3' 006 '2');
CATEGORY_NAME_SHORT/A100 = IF CATEGORY_NAME EQ 'AVERAGE NUMBER OF DAYS FROM INVOICE DATE TO RECEIPT DATE' THEN 'INVOICE DATE TO RECEIPT DATE' ELSE IF CATEGORY_NAME EQ 'AVERAGE NUMBER OF DAYS FROM INVOICE DATE TO PAYMENT DATE' THEN 'INVOICE DATE TO PAYMENT DATE' ELSE IF CATEGORY_NAME EQ 'AVERAGE NUMBER OF DAYS FROM RECEIPT DATE TO CLOSE DATE' THEN 'RECEIPT DATE TO CLOSE DATE' ELSE '';
END

-*IA_GRAPH_BEGIN
-*Do not delete or modify the comments below


*-INTERNAL_COMMENT LINE#0$PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiIHN0YW5kYWxvbmU9Im5vIj8+DQo8IS0tMS4wLS0+DQo8Um9vdCB2ZXJzaW9uPSIxLjAiPg0KICAgIDxPYmplY3Qgb2JqZWN0SWQ9IkNoYXJ0XzEiPg0KICAgICAgICA8UHJvcGVydHkgbmFtZT0iTGlua2VkU29ydHMiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciLz4NCiAgICA8L09iamVjdD4NCiAgICA8T2JqZWN0IG9iamVjdElkPSJHTE9CQUwiPg0KICAgICAgICA8UHJvcGVydHkgbmFtZT0iU2FtcGxlRGF0YSIgdHlwZT0iamF2YS5sYW5nLkJvb2xlYW4iPmZhbHNlPC9Qcm9wZXJ0eT4NCiAgICAgICAgPFByb3BlcnR5IG5hbWU9Ikdsb2JhbFJlY29yZExpbWl0IiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj41MDA8L1Byb3BlcnR5Pg0KICAgICAgICA8UHJvcGVydHkgbmFtZT0iR2xvYmFsUnVuUmVjb3JkTGltaXQiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPjA8L1Byb3BlcnR5Pg0KICAgICAgICA8UHJvcGVydHkgbmFtZT0iZmllbGREaXNwbGF5TW9kZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+bGFiZWw8L1Byb3BlcnR5Pg0KICAgICAgICA8UHJvcGVydHkgbmFtZT0icHJlZml4RGlzcGxheU1vZGUiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciLz4NCiAgICAgICAgPFByb3BlcnR5IG5hbWU9IkFjdGl2ZV9TdHlsZV9Vc2VyX3R5cGUiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPnBvd2VyPC9Qcm9wZXJ0eT4NCiAgICAgICAgPFByb3BlcnR5IG5hbWU9Ikdsb2JhbFZhbHVlc1BhZ2luZyIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+NDwvUHJvcGVydHk+DQogICAgICAgIDxQcm9wZXJ0eSBuYW1lPSJGb2NleGVjUHJlZmVyZW5jZXMiIHR5cGU9Ik1hcCI+DQogICAgICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5RWRpdE1vZGVJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPmZhbHNlPC9FbnRyeT4NCiAgICAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlGb3JtYXRUYWJJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPnRydWU8L0VudHJ5Pg0KICAgICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheUhvbWVUYWJJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPmZhbHNlPC9FbnRyeT4NCiAgICAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlRdWlja0FjY2Vzc1Rvb2xiYXJTYXZlSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj50cnVlPC9FbnRyeT4NCiAgICAgICAgICAgIDxFbnRyeSBrZXk9Im1ldGFkYXRhX3ZpZXdzIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj5NZXRhRGF0YVRyZWUuVklFV19ESU1TPC9FbnRyeT4NCiAgICAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlSZXNvdXJjZXNGaWVsZFRhYkluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+ZmFsc2U8L0VudHJ5Pg0KICAgICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheUluc2VydFRhYkluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+ZmFsc2U8L0VudHJ5Pg0KICAgICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheVNsaWNlcnNUYWJFZGl0SW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj5mYWxzZTwvRW50cnk+DQogICAgICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5U2VyaWVzVGFiSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj5mYWxzZTwvRW50cnk+DQogICAgICAgICAgICA8RW50cnkga2V5PSJpbmZvQXNzaXN0TW9kZUFsbG93ZWRJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPmZhbHNlPC9FbnRyeT4NCiAgICAgICAgICAgIDxFbnRyeSBrZXk9ImRlZmF1bHRfcHJldmlld19wYWdlbGltaXRfbGF5b3V0IiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj4xPC9FbnRyeT4NCiAgICAgICAgICAgIDxFbnRyeSBrZXk9ImRlZmF1bHRfcHJldmlld19wYWdlbGltaXQiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPjU8L0VudHJ5Pg0KICAgICAgICAgICAgPEVudHJ5IGtleT0iZGVmYXVsdF9jb21wb3NlX2Zvcm1hdCIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+UERGPC9FbnRyeT4NCiAgICAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlJbnRlcmFjdGl2ZU1vZGVJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPnRydWU8L0VudHJ5Pg0KICAgICAgICAgICAgPEVudHJ5IGtleT0icnVuT25TdGFydHVwSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj50cnVlPC9FbnRyeT4NCiAgICAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlEYXRhVGFiSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj5mYWxzZTwvRW50cnk+DQogICAgICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5U2xpY2Vyc1RhYkludGVyYWN0aXZlSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIj50cnVlPC9FbnRyeT4NCiAgICAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlMYXlvdXRUYWJJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPmZhbHNlPC9FbnRyeT4NCiAgICAgICAgPC9Qcm9wZXJ0eT4NCiAgICAgICAgPFByb3BlcnR5IG5hbWU9ImNhc2NhZGVOYW1lcyIgdHlwZT0iTWFwIi8+DQogICAgICAgIDxQcm9wZXJ0eSBuYW1lPSJNYXN0ZXJfRmlsZXMiIHR5cGU9IlNldCI+DQogICAgICAgICAgICA8RW50cnkgdHlwZT0iamF2YS5sYW5nLlN0cmluZyI+UFNRTE9VVDwvRW50cnk+DQogICAgICAgIDwvUHJvcGVydHk+DQogICAgICAgIDxQcm9wZXJ0eSBuYW1lPSJtZXRhZGF0YVZpZXdBcyIgdHlwZT0iTWFwIj4NCiAgICAgICAgICAgIDxFbnRyeSBrZXk9
*-INTERNAL_COMMENT LINE#1$IlBTUUxPVVQiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciPk1ldGFEYXRhVHJlZS5WSUVXX0RJTVM8L0VudHJ5Pg0KICAgICAgICA8L1Byb3BlcnR5Pg0KICAgICAgICA8UHJvcGVydHkgbmFtZT0iZW5hYmxlUHJldmlldyIgdHlwZT0iamF2YS5sYW5nLkJvb2xlYW4iPnRydWU8L1Byb3BlcnR5Pg0KICAgIDwvT2JqZWN0Pg0KPC9Sb290Pg0K
-*Do not delete or modify the comments above
ENGINE INT CACHE SET ON
-DEFAULTH &WF_STYLE_UNITS='PIXELS';
-DEFAULTH &WF_STYLE_HEIGHT='200.0';
-DEFAULTH &WF_STYLE_WIDTH='420.0';
GRAPH FILE PSQLOUT
-* Created by Info Assist for Graph
SUM PSQLOUT.PSQLOUT.YTD AS 'TOTAL'
BY PSQLOUT.PSQLOUT.SORT NOPRINT
BY PSQLOUT.PSQLOUT.CATEGORY_NAME_SHORT
WHERE PSQLOUT.PSQLOUT.YTD NE 0;
WHERE PSQLOUT.PSQLOUT.CATEGORY_NAME_SHORT NE '';
ON GRAPH HOLD AS TIMELINE FORMAT JSCHART
ON GRAPH SET VZERO OFF
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET 3D OFF
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET UNITS &WF_STYLE_UNITS
ON GRAPH SET HAXIS &WF_STYLE_WIDTH
ON GRAPH SET VAXIS &WF_STYLE_HEIGHT
ON GRAPH SET GRMERGE ON
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 2
ON GRAPH SET LOOKGRAPH HBAR
ON GRAPH SET AUTOFIT OFF
ON GRAPH SET GRAPHEDIT ON
ON GRAPH SET STYLE *
*GRAPH_SCRIPT
setPieDepth(0);
setPieTilt(0);
setDepthRadius(0);
setCurveFitEquationDisplay(false);
setPlace(true);

-*setUseSeriesShapes(true);


setMarkerSizeDefault(50);
*END
INCLUDE=endeflt.sty,$
TYPE=REPORT, TITLETEXT='WebFOCUS Report', $
TYPE = TITLE, TARGET='_blank', FOCEXEC=processingtimelinelinegraph.fex( \

CATEGORY_NAME = CATEGORY_NAME_SHORT \
CUSTOMER_KEY=&CUSTOMER_KEY.QUOTEDSTRING \
CLOSEOUT_DATE=&CLOSEOUT_DATE.QUOTEDSTRING \
DRILL= 'Y'
)
, $


*GRAPH_SCRIPT
setReportParsingErrors(false);
setSelectionEnableMove(false);
setLabelStagger(getO1Label(),true);
setToolTipMode(false);
setUserToolTip("TOTAL: [YV]");
setFontName(getY1Title(),"VERDANA");
setFillColor(getY1Title(),new Color(0,0,0));
setFontName(getO1Title(),"VERDANA");
setFillColor(getO1Title(),new Color(0,0,0));
setTextString(getY1Title(),"YTD VALUE");
setDisplay(getY1Title(),true);
setTextString(getO1Title(),"CATEGORY");
setDisplay(getO1Title(),true);
setDisplay(getO1Title(),true);
setDisplay(getY1Title(),true);
setFontSizeAbsolute(getLegendText(),true);
setFontSizeInPoints(getLegendText(),8);
setFontName(getLegendText(),"Verdana");
setPlaceResize(getLegendText(), 0);
setFontName(getDataText(),"Verdana");
setTransparentFillColor(getFrame(),true);
setFontSizeAbsolute(getO1Label(), true);
setFontSizeInPoints(getO1Label(), 8);
setPlaceResize(getO1Label(), 0);
setTextJustHoriz(getO1Label(),1);
setFillColor(getFrame(),new Color(234, 234, 247));
setFillColor(getChartBackground(),new Color(255,255,255));
setFontName(getY1Title(),"VERDANA");
setFontSizeInPoints(getY1Title(),8);
setFontStyle(getY1Title(),2);
setFillColor(getY1Title(),new Color(0,0,0));
setFontName(getO1Title(),"VERDANA");
setFontSizeInPoints(getO1Title(),8);
setFontStyle(getO1Title(),2);
setFillColor(getO1Title(),new Color(0,0,0));
-*-*-*-*-*-*setO1LabelStagger(false);
-*-*-*-*-*-*setO1LabelWrap(true);
-*-*-*-*-*-*setLabelStagger(getO1Label(),true);
-*-*-*-*-*-*setLabelWrap(getO1Label(),true);
-*-*-*-*-*-*setLabelMargin(getO1Label(),10);
-*-*-*-*-*-*setO1LabelAutofit(true);
-*-*-*-*-*-*setO1AxisSide(1);
*END


What is happening here is that "CATEGORY_NAME_SHORT" field values are coming as X-axis labels and those are not fitting side-by-side to the horizontal stacked bar graph. The labels are coming like "INVOICE DATE TO..."(just for eg.), i want full names of labels to be displayed side of the graph.

I do not want to reduce font sizes of labels as they would affect the required look n feel of KPIs. I want any option available for fitting the x-axis labels side-by-side of the graph without changing the graph style or font style.