Hello

I am working on a graph which works fine in JSCHART format. But in PDF, I am having an issue. Month number displays on X axis from 1 to 12. I also have a month name field and I want that to display on X-axis and use month number field as sort. Please suggest.

   
GRAPH FILE TAB_NAME
SUM AMT AS ''
BY YEAR_VAL AS ''
ACROSS MONTH_NUM
ON GRAPH PCHOLD FORMAT PDF
ON GRAPH SET VZERO OFF
ON GRAPH SET AUTOFIT ON
ON GRAPH SET GRWIDTH 1
ON GRAPH SET UNITS INCHES
ON GRAPH SET HAXIS 8
ON GRAPH SET VAXIS 4
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 1
ON GRAPH SET GRXAXIS 1
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET STYLE *
*GRAPH_SCRIPT
setMarkerSizeDefault(50);
ENDSTYLE
END

This message has been edited. Last edited by: WebFOCUS_Dev,

Could you use NOPRINT on month number? Something like:

ACROSS MONTH_NUM NOPRINT
ACROSS MONT_NAME

Create a DEFINE field of format Mt and use it as the ACROSS field.

 
MONTH_Mt/Mt = MONTH_NUM;
 

Here is an example using the ggsales file:

 
DEFINE FILE ibisamp/ggsales
 Date_YYMD/YYMD = DATE ;
 Date_Mt/Mt = Date_YYMD; 
 Date_YY/YY = Date_YYMD ;
END
GRAPH FILE ibisamp/ggsales
SUM UNITS AS ''
BY Date_YY AS ''
ACROSS Date_Mt AS ''
ON GRAPH PCHOLD FORMAT PDF
ON GRAPH SET VZERO OFF
ON GRAPH SET AUTOFIT ON
ON GRAPH SET GRWIDTH 1
ON GRAPH SET UNITS INCHES
ON GRAPH SET HAXIS 8
ON GRAPH SET VAXIS 4
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 1
ON GRAPH SET GRXAXIS 1
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET STYLE *
*GRAPH_SCRIPT
setMarkerSizeDefault(50);
ENDSTYLE
END