January 15, 2008, 09:57 AM
DonFSuppressing Zero values on a stacked bar graph
Does anyone know how to suppress the zero values in a stacked bar graph? They show as 0 on the zero axis as they should, but add a distraction to the overall look.
Here is my code:
DEFINE FILE CAR
CRITICAL/I4 MISSING ON = IF COUNTRY EQ 'JAPAN' THEN SEATS ELSE 0;
HIGH/I4 MISSING ON = IF COUNTRY EQ 'ENGLAND' THEN SEATS ELSE 0;
MEDIUM/I4 MISSING ON = IF COUNTRY EQ 'FRANCE' THEN SEATS ELSE 0;
LOW/I4 MISSING ON = IF COUNTRY EQ 'GERMANY' THEN SEATS ELSE 0;
END
SET GRMERGE=ON
GRAPH FILE CAR
SUM LOW MEDIUM HIGH CRITICAL
BY HIGHEST TOTAL RETAIL_COST AS ''
BY CAR AS ''
ON GRAPH SET LOOKGRAPH HBRSTK1
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB ON
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO OFF
ON GRAPH SET GRID OFF
ON GRAPH SET VAXIS 425
ON GRAPH SET HAXIS 450
ON GRAPH SET GRWIDTH 0
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET GRAPHSTYLE *
setCustomDataText(getSeries (0),true);
setDataTextPosition(1);
setY1AxisSide(0);
setStackedDataValueSum(false);
setMarkerDisplay(true);
setConnectLineMarkers(false);
setConnectScatterMarkers(false);
setO1LabelDisplay(true);
setO1AxisSide(0);
setO1MajorGridDisplay(false);
setO1MinorGridDisplay(false);
setAxisAssignment(0,0);
setSeriesType(0,1);
setAxisAssignment(1,0);
setAxisAssignment(2,0);
setAxisAssignment(3,0);
setY1LabelDisplay(false);
setY1MajorGridDisplay(false);
setY1MinorGridDisplay(false);
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getY1Label(),"#.##");
setPieFeelerTextDisplay(1);
setPieLabelDisplay(0);
setTextFormatPreset(getPieSliceLabel(),1);
setRiserBorderMode(1);
setSeriesDefaultTransparentBorderColor(true);
setUseSeriesBorderDefaults(true);
setLegendDisplay(true);
setTextJustHoriz(getLegendText(),1);
setFontSizeAbsolute(getLegendText(),true);
setFontSize(getLegendText(),12);
setFillColor(getLegendText(),new Color(0,0,128));
setTextRotation(getLegendText(),0);
setTextWrap(getLegendText(),false);
setTextJustHoriz(getY1Title(),1);
setFontSizeAbsolute(getY1Title(),true);
setFontSize(getY1Title(),12);
setFillColor(getY1Title(),new Color(0,0,128));
setTextRotation(getY1Title(),1);
setTextWrap(getY1Title(),false);
setTextJustHoriz(getY1Label(),2);
setFontSizeAbsolute(getY1Label(),true);
setFontSize(getY1Label(),12);
setFontStyle(getY1Label(),2);
setFillColor(getY1Label(),new Color(0,0,128));
setTextRotation(getY1Label(),0);
setTextWrap(getY1Label(),false);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setTextJustHoriz(getO1Title(),1);
setFontSizeAbsolute(getO1Title(),true);
setFontSize(getO1Title(),12);
setFillColor(getO1Title(),new Color(0,0,128));
setTextRotation(getO1Title(),0);
setTextWrap(getO1Title(),false);
setTextJustHoriz(getO1Label(),0);
setFontSizeAbsolute(getO1Label(),true);
setFontSize(getO1Label(),12);
setFontStyle(getO1Label(),2);
setFillColor(getO1Label(),new Color(0,0,128));
setTextRotation(getO1Label(),0);
setTextWrap(getO1Label(),false);
setPlaceResize(getTitle(),0);
setPlaceRotate(getTitle(),0);
setPlaceAlign(getTitle(),0);
setPlaceWordWrap(getTitle(),0);
setPlaceResize(getLegendText(),0);
setPlaceRotate(getLegendText(),0);
setPlaceAlign(getLegendText(),0);
setPlaceWordWrap(getLegendText(),0);
setPlaceResize(getY1Title(),0);
setPlaceRotate(getY1Title(),0);
setPlaceAlign(getY1Title(),0);
setPlaceWordWrap(getY1Title(),0);
setPlaceResize(getY1Label(),0);
setPlaceRotate(getY1Label(),0);
setPlaceAlign(getY1Label(),0);
setPlaceWordWrap(getY1Label(),0);
setPlaceResize(getO1Title(),0);
setPlaceRotate(getO1Title(),0);
setPlaceAlign(getO1Title(),0);
setPlaceWordWrap(getO1Title(),0);
setPlaceResize(getO1Label(),0);
setPlaceRotate(getO1Label(),0);
setPlaceAlign(getO1Label(),0);
setPlaceWordWrap(getO1Label(),0);
setPlace(true);
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