[CLOSED] Need Trend Line in Line with Sum of Stacked Graph Column
Hello,
I am currently trying to make a trend line display in relation to the sum of a stacked graph and not in relation to the highest value in the stacked graph. In the CAR example below, the trend line in column "4" should be in line with the sum between RETAIL_COST and DEALER_COST. Does anyone have an idea how to do this? Thanks in advance!!
GRAPH FILE CAR
SUM
DEALER_COST
RETAIL_COST
SALES
BY SEATS AS ' '
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET VZERO OFF
ON GRAPH SET ARGRAPHENGIN JSCHART
ON GRAPH SET GRWIDTH 1
ON GRAPH SET AUTOFIT ON
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET LOOKGRAPH VBRSTK1
ON GRAPH SET STYLE *
*GRAPH_SCRIPT
setPieDepth(0);
setPieTilt(0);
setDepthRadius(0);
setPlace(true);
setCurveFitEquationDisplay(false);
*END
TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, ORIENTATION=LANDSCAPE, $
TYPE=HEADING, JUSTIFY=CENTER, FONT='ARIAL', STYLE=BOLD, SIZE=11, COLOR=RGB(75 75 75), $
*GRAPH_SCRIPT
setReportParsingErrors(false);
setFillColor(getDataText(0), new Color(255,255,255));
setSelectionEnableMove(false);
setSeriesType(2,2);
setLegendPosition(1);
setDisplay(getY1Title(),true);
setFillColor(getSeries(0),new Color(0,77,113));
setFillColor(getSeries(1),new Color(124,201,126));
setFillColor(getSeries(2),new Color(6,194,255));
setDataTextDisplay(true);
-*setTextFormatPreset(getDataText(),6);
setDataTextPosition(4);
setDisplay(getY1AxisLine(),false);
setDisplay(getY1Label(),false);
setDisplay(getY1MajorTick(),false);
setY2LabelDisplay(true);
setY2AxisSide(0);
setY2MajorGridDisplay(true);
setY2MajorGridStyle(0);
setY2MinorGridDisplay(false);
*GRAPH_JS_FINAL
"xaxis": {
"title": {
"visible": false
}
}
*END
ENDSTYLE
END
-RUN
-*IA_GRAPH_FINISH
-RUN