Hi All,

I am using dual axis bar stack chart to display the comparison between 4 values.( i.e.
current year sales and gross sales vs last year sales and gross value .) if I am not setting max scale values to both the axis (Y1 & Y2) the scales bar does not shows proper comparison. And some time one axis(Y2) min value (Current Year) bar has larger than other axis (Y1)(last year) . So i fixed the both y-axis max value and min value. but some time top 2 scale values overlaps to each other ,

Pleas suggest any workaround to fix this.

 BY ID AS '&SORTTITLE'
ON GRAPH PCHOLD FORMAT PDF
ON GRAPH SET VZERO OFF
ON GRAPH SET GRWIDTH 1
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 ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET AUTOFIT ON
ON GRAPH SET LOOKGRAPH HBRSTK2
ON GRAPH SET STYLE *
*GRAPH_SCRIPT
setPieDepth(0);
setPieTilt(0);
setDepthRadius(0);
setPlace(true);
setCurveFitEquationDisplay(false);
*END
TYPE=HEADING, JUSTIFY=CENTER, FONT='ARIAL', SIZE=16, COLOR=RGB(0 51 102), STYLE=NORMAL, $
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/ibi_themes/Warm.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, $
*GRAPH_SCRIPT
setFillColor(getSeries(0),new Color(80,203,208));
setFillColor(getSeries(2),new Color(80,203,208));
setFillColor(getSeries(1),new Color(96,120,183));
setFillColor(getSeries(3),new Color(96,119,183));
setBorderColor(getSeries(1),new Color(59,74,114));
setBorderColor(getSeries(0),new Color(55,139,143));
setBorderColor(getSeries(2),new Color(54,139,143));
setBorderColor(getSeries(3),new Color(59,73,114));
setReportParsingErrors(false);
setSelectionEnableMove(false);
setTextFormatPreset(getY1Label(),1);
setY1LabelFormat(16);

setY1LogScale(false);
setScaleMinAuto(getY1Axis(),false);
setScaleMin(getY1Axis(),&MINSCALE);
setScaleMaxAuto(getY1Axis(),false);
setScaleMustIncludeZero(getY1Axis(),false);
setScaleMax(getY1Axis(),&MAXSCALE);
setY2LogScale(false);
setScaleMinAuto(getY2Axis(),false);
setScaleMin(getY2Axis(),&MINSCALE);
setScaleMaxAuto(getY2Axis(),false);
setScaleMax(getY2Axis(),&MAXSCALE);
setScaleMustIncludeZero(getY2Axis(),false);

setGridStepAuto(getY2MajorGrid(),true);
setAxisAssignment( $0, 0);
setAxisAssignment( $1, 0);
setAxisAssignment( $2, 1);
setAxisAssignment( $3, 1);
setDisplay(getO1Title(),false);
setDisplay(getY2Label(),false);
setDisplay(getLegendArea(),false);
setTextRotation(getO1Label(),3);
setDisplay(getY2AxisLine(),false);
setDisplay(getY2Label(),false);
setDisplay(getY2MajorTick(),false);

*GRAPH_JS_FINAL
"xaxis": {
    "title": {
        "visible": false
    }
},
"pieProperties": {
    "holeSize": "0%"
},
"blaProperties": {
    "seriesLayout": "stacked"
},
"agnosticSettings": {
    "dual": true,
    "chartTypeFullName": "Bar_Stacked_Dual_Axis"
}
*END
ENDSTYLE
END
-RUN

Chart Image URL

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

I got the solution by adding the Grid Step and now closing this.

-SET &STEP= (&MAXVALUE/5);

 setGridStepAuto(getY1MajorGrid(),false);
setGridStep(getY1MajorGrid(), &STEP);