Focal Point
Suppressing Zero values on a stacked bar graph

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/3461002662

January 15, 2008, 09:57 AM
DonF
Suppressing 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
January 15, 2008, 10:32 AM
jamie
Would you like to set the zero value to a gap instead? You do not mention what release you're on, but there is 7.1.3 documantation on this at:
http://documentation.informationbuilders.com/masterinde...x.htm#lng_gphval.htm

Hopefully you can find something here that can help you.

Jamie
January 16, 2008, 09:20 AM
gregv
DonF: Add this to your code.

WHERE (LOW+MEDIUM+HIGH+CRITICAL) GT 0;

Greg



Greg



current client: WF 8.1.05 & 8.2 - Windows 7 64bit - Tomcat 7 - MRE / BID - IE11

local: WF 8.2 - Windows 7 64bit - Tomcat 6 - MRE / BID - FOCUS - IE11

PMF 8