-*FP Post: http://forums.informationbuild...717049886#7717049886
-* 166344 is the result from the below code is used for setScaleMax and setGridStep.
-*SUM DCOST RCOST DCOST RCOST
-*BY LOWEST 1 COUNTRY NOPRINT
-*ON TABLE ROW-TOTAL
-*END
-*-EXIT
ENGINE INT CACHE SET ON
-DEFAULTH &WF_STYLE_UNITS='PIXELS';
-DEFAULTH &WF_STYLE_HEIGHT='405.0';
-DEFAULTH &WF_STYLE_WIDTH='770.0';
-DEFAULTH &WF_TITLE='WebFOCUS Report';
-*IA_GRAPH_BEGIN
-*Do not delete or modify the comments below
*I know it says not to, but, I removed these lines.
-*Do not delete or modify the comments above
ENGINE INT CACHE SET ON
-DEFAULTH &WF_STYLE_UNITS='PIXELS';
-DEFAULTH &WF_STYLE_HEIGHT='405.0';
-DEFAULTH &WF_STYLE_WIDTH='770.0';
-DEFAULTH &WF_TITLE='WebFOCUS Report';
GRAPH FILE CAR
HEADING
"&TOD &DATEMtDYY"
-* Created by Info Assist for Graph
SUM DCOST RCOST DCOST RCOST
BY LOWEST 1 COUNTRY NOPRINT
ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET VZERO OFF
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET AUTOFIT ON
ON GRAPH SET UNITS &WF_STYLE_UNITS
ON GRAPH SET HAXIS &WF_STYLE_WIDTH
ON GRAPH SET VAXIS &WF_STYLE_HEIGHT
ON GRAPH SET LOOKGRAPH BAR
ON GRAPH SET AUTOFIT ON
ON GRAPH SET STYLE *
*GRAPH_SCRIPT
setPieDepth(0);
setPieTilt(0);
setDepthRadius(0);
setPlace(true);
setCurveFitEquationDisplay(false);
*END
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/ibi_themes/Warm.sty,$
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, $
TYPE=DATA, COLUMN=N1, BUCKET=x-axis, $
TYPE=DATA, COLUMN=N2, BUCKET=y-axis, $
TYPE=DATA, COLUMN=N3, BUCKET=y-axis, $
TYPE=DATA, COLUMN=N4, BUCKET=y-axis, $
TYPE=DATA, COLUMN=N5, BUCKET=y-axis, $
*GRAPH_SCRIPT
setReportParsingErrors(false);
setSelectionEnableMove(false);
setDisplay(getLegendArea(),false);
setDisplay(getO1Label(),false);
setDisplay(getO1AxisLine(),false);
setExcludeMinLabel(getO1Label(),true);
setExcludeMaxLabel(getO1Label(),true);
setDisplay(getY1Label(),false);
setScaleMinAuto(getY1Axis(),false);
setScaleMaxAuto(getY1Axis(),false);
setGridStepAuto(getY1MajorGrid(),false);
setScaleMustIncludeZero(getY1Axis(),false);
setDisplay(getY1AxisLine(),false);
setDisplay(getY1ZeroLine(),false);
setFillColor(getSeries(0),new Color(0,128,0));
setTransparentBorderColor(getSeries(0), true);
setFillColor(getSeries(1),new Color(255,255,0));
setTransparentBorderColor(getSeries(1), true);
setFillColor(getSeries(2),new Color(255,128,0));
setTransparentBorderColor(getSeries(2), true);
setFillColor(getSeries(3),new Color(255,0,0));
setTransparentBorderColor(getSeries(3), true);
setScaleMin(getY1Axis(),0.0);
setScaleMax(getY1Axis(),166344.0);
setGridStep(getY1MajorGrid(),166344.0);
*GRAPH_JS_FINAL
"pieProperties": {
    "holeSize": "0%"
},
"blaProperties": {
    "seriesLayout": "stacked",
    "orientation": "horizontal"
},
"agnosticSettings": {
    "chartTypeFullName": "Bar_Stacked_Horizontal"
}
*END
ENDSTYLE
END
-RUN

-*IA_GRAPH_FINISH
-RUN

In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.    Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206

quote:

Tick Removal

Francis

Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server