June 28, 2006, 02:58 PM
SuzanneConditional Marker Colors in a Graph - Possible?
Is it possible to change a marker color on a line graph depending on the value? (WebFocus 5.3) Thanks for any suggestions!
June 29, 2006, 08:46 AM
<JG>Suzanne
look at the following post
https://forums.informationbuilders.com/eve/forums/a/tpc/...241081861#9241081861Change the graphtype to VLINE and change setConnectLineMarkers(false); to setConnectLineMarkers(true);
As well as changing the marker color it also changes the color of the line from the afected point.
June 29, 2006, 03:51 PM
SuzanneI couldn't get it to work. Is it possible on a VBAR2AX graph?
June 30, 2006, 05:47 AM
<JG>When you say VBAR2AX I assume that one of the series has been set to display as a line.
The following code which is basically as the original works for VBAR2AX.
The important thing is that 1st value assigned in the COMPUTE FRED to
setExceptionalRiser and getExceptionalRiser must be the series number of the line plot
Because its java the 1st series is 0 and the 2nd series is 1
TABLE FILE CAR
SUM RETAIL_COST NOPRINT
COMPUTE COUNTER/I9= LAST COUNTER +1; NOPRINT
-* required because the java API starts counting from 0
COMPUTE COUNTER/I9= COUNTER -1; NOPRINT
COMPUTE FRED/A100= IF C1 LE 6000 THEN 'setExceptionalRiser(1,' || EDIT(C3) || '); ' |
'setFillColor(getExceptionalRiser(1,' || EDIT(C3) || '),new Color(255,0,0));' ELSE ' ';
BY MODEL NOPRINT
ON TABLE SET HOLDLIST PRINTONLY
ON TABLE SAVE
END
-RUN
GRAPH FILE CAR
SUM DEALER_COST RETAIL_COST
ACROSS MODEL
ON GRAPH SET LOOKGRAPH VBAR2AX
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO ON
ON GRAPH SET GRID OFF
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET GRAPHSTYLE *
setMarkerDisplay(true);
setConnectLineMarkers(true);
setConnectScatterMarkers(true);
setO1LabelDisplay(true);
setO1AxisSide(0);
setO1MajorGridDisplay(false);
setO1MinorGridDisplay(false);
setAxisAssignment(0,0);
setSeriesType(0,1);
setAxisAssignment(1,1);
setSeriesType(1,2);
setY1LabelDisplay(true);
setY1AxisSide(2);
setY1MajorGridDisplay(false);
setY1MinorGridDisplay(false);
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getY1Label(),"#.##");
setY2LabelDisplay(true);
setY2AxisSide(1);
setY2MajorGridDisplay(false);
setY2MinorGridDisplay(false);
setTextFormatPreset(getY2Label(),-1);
setTextFormatPattern(getY2Label(),"#.##");
setPieFeelerTextDisplay(1);
setPieLabelDisplay(0);
setTextFormatPreset(getPieSliceLabel(),1);
setRiserBorderMode(1);
setSeriesDefaultTransparentBorderColor(true);
setUseSeriesBorderDefaults(true);
setLegendDisplay(true);
setFontSizeAbsolute(getY1Title(),true);
setFontSizeAbsolute(getY1Label(),true);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setFontSizeAbsolute(getO1Title(),true);
setPlace(true);
-INCLUDE SAVE
ENDSTYLE
ON GRAPH SET STYLE *
PAGESIZE='Letter',
LEFTMARGIN=0.250000,
RIGHTMARGIN=0.250000,
TOPMARGIN=0.250000,
BOTTOMMARGIN=0.250000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
BACKCOLOR='NONE',
STYLE=NORMAL,
$
ENDSTYLE
END