Hi,

Is it possible to create Stacked Bar with Lines connecting the edge of each bar?

Refer the lines in red



Is there any workaround to get this done using WebFOCUS?

This message has been edited. Last edited by: Kerry,

This isn't exactly what you wanted, but maybe it is a start. I haven't looked in the graph manual yet.

-* File car_stackedbar.fex
-*INTERNAL_PROPERTIES$SampleData=false;OBJECTID=GLOBAL
-*INTERNAL_PROPERTIES$GlobalRecordLimit=500;OBJECTID=GLOBAL
-*INTERNAL_PROPERTIES$FieldDisplayMode=label;OBJECTID=GLOBAL
-*INTERNAL_PROPERTIES$PrefixDisplayMode=;OBJECTID=GLOBAL
GRAPH FILE CAR
-* Created by Advanced Graph Assistant
SUM CAR.BODY.DEALER_COST
CAR.BODY.DEALER_COST
CAR.BODY.RETAIL_COST
CAR.BODY.RETAIL_COST
BY CAR.ORIGIN.COUNTRY
ON GRAPH PCHOLD AS HOLD FORMAT PNG
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET HAXIS 770
ON GRAPH SET VAXIS 405
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH VBRSTK1
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET GRAPHSTYLE *
setTemplateFile("/images/tdg/template/IBISouthWestern.txt");
setReportParsingErrors(false);
setSelectionEnableMove(false);
setTransparentBorderColor(getChartBackground(),true);
setPlace(true);
setFontSizeInPoints(getReferenceLineTextY1(2), 12);
setPlaceResize(getReferenceLineTextY1(2), 0);
setFontSizeAbsolute(getReferenceLineTextY1(2), false);
setSeriesType(getSeries(1),2);
setSeriesType(getSeries(3),2);
setFillColor(getSeries(3),new Color(255,0,0));
setFillColor(getSeries(1),new Color(255,0,0));
setLineWidth(getSeries(1),1);
setLineWidth(getSeries(3),1);
setDepthRadius(0);
setDepthAngle(0);
setMarkerShape(getSeries(1),0);
setMarkerShape(getSeries(3),0);
ENDSTYLE
END

Nice reply Ginny, in less then a hour from the original post...

Ram Prasad E: What is the source of your sample?

Building on Ginny's quick example:

I changed the color of series(1) to blue just for identification, as follows:
setFillColor(getSeries(1),new Color(0,0,255));

I added the following line to get stepping as the last line before ENDSTYLE:
setConnectLineStep(getSeries(1),true);

Add these two lines as desired:
setLineBasicStrokeType(getSeries(1),4);
setLineWidth(getSeries(1),2);

Now to angle those "steps"...

Ginny,
Thanks for the Quick response.

I followed same, by repeating entire set of series for Bar and again for Line. But not able to get the line in the edge of the Bar.

Line is drawn from mid of the Bar. Is it possible to move that to tip of the bar?

Ram Prasad

if you post your code (adviced to do it on one of the test/learning sets like CAR) we can better help by looking at the codes you have used.

Ram, Have you tried Ginny's code (Posted Wed Feb 24 2010 13:19" with my lines added (Posted Wed Feb 24 2010 18:27) to see those results.

Also, would you please post your code so that we can help you. It seems that we are helping you to do something that might not be what asking...

Hi All,

Here is the code that am using

DEFINE FILE CAR
COUNTRY_C/A10=DECODE COUNTRY('ENGLAND' '2Q08' 'FRANCE' '3Q08' 'ITALY' '4Q08' 'JAPAN' '1Q09' 'W GERMANY' '2Q09');
LENGTH_M/I2=DECODE COUNTRY('ENGLAND' 1 'FRANCE' 2 'ITALY' 3 'JAPAN' 1 'W GERMANY' 1);
DEALER_COST_M/I2=DECODE COUNTRY('ENGLAND' 1 'FRANCE' 1 'ITALY' 2 'JAPAN' 3 'W GERMANY' 4);
RETAIL_COST_M/I2=DECODE COUNTRY('ENGLAND' 3 'FRANCE' 2 'ITALY' 4 'JAPAN' 2 'W GERMANY' 1);
SALES_M/I2=DECODE COUNTRY('ENGLAND' 2 'FRANCE' 4 'ITALY' 4 'JAPAN' 1 'W GERMANY' 4);
END
GRAPH FILE CAR
SUM
DEALER_COST_M AS '0-1'
RETAIL_COST_M AS '2'
SALES_M AS '3'
LENGTH_M AS '4+'

DEALER_COST_M AS ''
RETAIL_COST_M AS ''
SALES_M AS ''
LENGTH_M AS ''

ACROSS COUNTRY_C AS ''
ON GRAPH SET LOOKGRAPH VBRSTK1
ON GRAPH SET GRAPHDEFAULT OFF

ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1

ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH SET VAXIS 3.000
ON GRAPH SET HAXIS 5.000

ON GRAPH SET UNITS INCHES
ON GRAPH HOLD AS IMG1 FORMAT SVG
ON GRAPH SET GRAPHSTYLE *
setMarkerDisplay(false);
setConnectLineMarkers(true);
setConnectScatterMarkers(false);
setO1LabelDisplay(true);
setO1AxisSide(0);
setO1MajorGridDisplay(false);
setO1MinorGridDisplay(false);

setLineWidth(getSeries(4),1);
setLineWidth(getSeries(5),1);
setLineWidth(getSeries(6),1);
setLineWidth(getSeries(7),1);
setDepthRadius(0);
setDepthAngle(0);

setDataTextFormat(1);
setDataTextDisplay(true);
setDataTextPosition(4);
setDataTextAngleDefault(270);
setDataTextRadiusDefault(50);

setDisplay(getDataText(4),false);
setDisplay(getDataText(5),false);
setDisplay(getDataText(6),false);
setDisplay(getDataText(7),false);

setRiserWidth(60);
setTransparentBorderColor(getFrame(), true);
setLegendDisplay(true);

setLegendAutomatic(true);
setTransparentBorderColor(getLegendArea(),false);
setBorderColor(getLegendArea(),new Color(0,0,0));
setBorderWidth(getLegendArea(),2);

setLegendPosition(3);
setLegendMarkersPerRow(1);
setLegendReverse(true);
setLeftInset(getLegendArea(), 250);

setLegendRect(new Rectangle(-11318,5359,3066,11438));
setFontSizeAbsolute(getLegendText(),true);
setFontSize(getLegendText(),12);
setTextRotation(getLegendText(),0);
setTextWrap(getLegendText(),false);
setFontStyle(getLegendText(),0);
setBorder(getLegendArea(),true);

setFontSizeAbsolute(getDataText(),true);
setFontSize(getDataText(),8);
setTextRotation(getDataText(),0);
setTextWrap(getDataText(),false);
setFontStyle(getDataText(),0);
setDisplay(getY1AxisLine(),false);
setDisplay(getFrame(),false);

setAxisAssignment(0,0);
setSeriesType(0,1);
setAxisAssignment(1,0);
setSeriesType(1,1);
setAxisAssignment(2,0);
setSeriesType(2,1);
setAxisAssignment(3,0);
setSeriesType(3,1);

setAxisAssignment(4,0);
setSeriesType(4,2);
setAxisAssignment(5,0);
setSeriesType(5,2);
setAxisAssignment(6,0);
setSeriesType(6,2);
setAxisAssignment(7,0);
setSeriesType(7,2);

setY1LabelDisplay(false);
setY1MajorGridDisplay(false);
setY1MinorGridDisplay(false);
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getY1Label(),"#.##");
setPieFeelerTextDisplay(1);
setPieLabelDisplay(0);
setTextFormatPreset(getPieSliceLabel(),1);
setRiserBorderMode(2);
setSeriesDefaultTransparentBorderColor(false);
setUseSeriesBorderDefaults(false);

setFontSizeAbsolute(getY1Title(),true);
setFontSizeAbsolute(getY1Label(),true);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setTextJustHoriz(getO1Title(),1);
setFontSizeAbsolute(getO1Title(),true);
setFontSize(getO1Title(),10);
setTextRotation(getO1Title(),0);
setTextWrap(getO1Title(),false);
setTextJustHoriz(getO1Label(),0);
setFontSizeAbsolute(getO1Label(),true);
setFontSize(getO1Label(),9);
setTextRotation(getO1Label(),0);
setTextWrap(getO1Label(),false);
setPlaceResize(getO1Title(),0);
setPlaceRotate(getO1Title(),0);
setPlaceAlign(getO1Title(),0);
setPlaceWordWrap(getO1Title(),0);
setPlaceResize(getO1Label(),0);
setPlaceRotate(getO1Label(),0);
setPlaceAlign(getO1Label(),0);
setPlaceWordWrap(getO1Label(),0);

setPlaceResize(getLegendText(),0);
setPlaceRotate(getLegendText(),0);
setPlaceAlign(getLegendText(),0);
setPlaceWordWrap(getLegendText(),0);

setPlace(true);
ENDSTYLE
ON GRAPH SET STYLE *
     PAGESIZE='Letter',
     LEFTMARGIN=0.0,
     RIGHTMARGIN=0.0,
     TOPMARGIN=0.0,
     BOTTOMMARGIN=0.0,
     SQUEEZE=ON,
     ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
     GRID=OFF,
     FONT='TIMES NEW ROMAN',
     SIZE=10,
     BACKCOLOR='NONE',
     STYLE=NORMAL,
$
TYPE=DATA,
     ACROSSCOLUMN=N1,
     COLOR=RGB(153 204 255),
$
TYPE=DATA,
     ACROSSCOLUMN=N2,
     COLOR=RGB(204 153 204),
$
TYPE=DATA,
     ACROSSCOLUMN=N3,
     COLOR=RGB(255 153 153),
$
TYPE=DATA,
     ACROSSCOLUMN=N4,
     COLOR=RGB(51 204 204),
$
TYPE=DATA,
     ACROSSCOLUMN=N5,
     COLOR=RGB(0 0 0),
$
TYPE=DATA,
     ACROSSCOLUMN=N6,
     COLOR=RGB(0 0 0),
$
TYPE=DATA,
     ACROSSCOLUMN=N7,
     COLOR=RGB(0 0 0),
$
TYPE=DATA,
     ACROSSCOLUMN=N8,
     COLOR=RGB(0 0 0),
$
ENDSTYLE
END
TABLE FILE CAR
SUM
SALES NOPRINT
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE PCHOLD FORMAT PDF
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
TYPE=REPORT, PAGESIZE='LETTER', ORIENTATION=LANDSCAPE, LEFTMARGIN=0.25, RIGHTMARGIN=0.25, $
TYPE=REPORT, IMAGE=IMG1.SVG, POSITION=(2.25 2), SIZE=(5 3), $
ENDSTYLE
END

Is it possible to get the line from right edge of 1st bar to left edge of 2nd bar? similarly for all bars.

This type of graph is not possible with current version. IBI took a request to consider in future release.