Hi,
I am creating a bubble graph where in , I need to show the one of the column data values near the bubbles in the graph.
I have pasted the code which I am trying with, in this I have a column fund_scheme_name which has names of the funds, I need to show these names near the bubbles. I can able to show other below values near the bubbles
ie
RTN_PER - [x]
STANDARD_DEVTN - [y]
CORPUS1 - [SIZE]
using the graph API, setDataTextTemplateBubble("<[Y]/[X]>");
Similarly, I need to show the names of the funds in the bubbles, Can any of you help me in this.
GRAPH FILE HOLD
SUM RTN_PER STANDARD_DEVTN CORPUS1 AS 'FUNDCODE'
BY FUND_SCHEME_NAME
ON GRAPH SET LOOKGRAPH BUBBLE
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB ON
ON GRAPH SET 3D ON
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
-TYPE &&RPT_TYPE
-IF &&RPT_TYPE EQ 'HTML' THEN GOTO HTMFORM ELSE IF &&RPT_TYPE EQ 'XLS' THEN GOTO XLSFORM ELSE GOTO PDFFORM;
-HTMFORM
ON GRAPH SET VAXIS 600
ON GRAPH SET HAXIS 800
-GOTO FORMEXIT
-XLSFORM
ON GRAPH HOLD AS BUBCHART FORMAT GIF
-GOTO FORMEXIT
-PDFFORM
ON GRAPH SET VAXIS 20
ON GRAPH SET HAXIS 20
ON GRAPH HOLD AS BUBBLEGRAPH FORMAT SVG
-FORMEXIT
ON GRAPH SET GRAPHSTYLE *
setTemplateFile("/images/tdg/template/IBIFadeToGrey.txt");
setReportParsingErrors(false);
setLineWidth(getQuadrantLine(),1);
setCubeSquareRisers(false);
setSelectionEnableMove(false);
setDepthRadius(0);
setMarkerSizeDefault(100);
setSeriesType(0, 0);
setConnectLineStep(getSeries(0),false);
setMarkerShape(getSeries(0), 2);
setSeriesFillColor(getSeries(0),new Color(140,175,239));
setSeriesType(1, 0);
setConnectLineStep(getSeries(1),false);
setMarkerShape(getSeries(1), 2);
setSeriesFillColor(getSeries(1),new Color(140,175,239));
setSeriesType(2, 0);
setConnectLineStep(getSeries(2),false);
setRiserWidth(70);
setMarkerShape(getSeries(2), 2);
setSeriesFillColor(getSeries(2),new Color(140,175,239));
setSeriesType(3, 0);
setConnectLineStep(getSeries(3),false);
setMarkerShape(getSeries(3), 2);
setSeriesFillColor(getSeries(3),new Color(140,175,239));
setSeriesType(4, 0);
setConnectLineStep(getSeries(4),false);
setMarkerShape(getSeries(4), 2);
setSeriesFillColor(getSeries(4),new Color(140,175,239));
setSeriesType(5, 0);
setConnectLineStep(getSeries(5),false);
setMarkerShape(getSeries(5), 2);
setMarkerShape(getSeries(6), 2);
setMarkerShape(getSeries(7), 2);
setMarkerShape(getSeries(8), 2);
setMarkerShape(getSeries(9), 2);
setMarkerShape(getSeries(10), 2);
setMarkerShape(getSeries(11), 2);
setMarkerShape(getSeries(12), 2);
setMarkerShape(getSeries(13), 2);
setMarkerShape(getSeries(14), 2);
setMarkerShape(getSeries(15), 2);
setMarkerShape(getSeries(16), 2);
setMarkerShape(getSeries(17), 2);
setMarkerShape(getSeries(18), 2);
setMarkerShape(getSeries(19), 2);
setMarkerShape(getSeries(20), 2);
setMarkerShape(getSeries(21), 2);
setMarkerShape(getSeries(22), 2);
setMarkerShape(getSeries(23), 2);
setMarkerShape(getSeries(24), 2);
setMarkerShape(getSeries(25), 2);
setMarkerShape(getSeries(26), 2);
setMarkerShape(getSeries(27), 2);
setMarkerShape(getSeries(28), 2);
setMarkerShape(getSeries(29), 2);
setMarkerShape(getSeries(30), 2);
setSmoothLines(false);
setSmoothAreas(false);
setUseTimeScaleAxis(false);
setReverseSeries(false);
setSeriesLooping(1);
setY2AxisSide(0);
setY2MajorGridDisplay(false);
setY2MinorGridDisplay(false);
setLegendMarkerPosition(1);
setMarkerDisplay(true);
setUseSeriesShapes(true);
setConnectLineMarkers(false);
setConnectScatterMarkers(false);
setO1LabelDisplay(false);
setO1MajorGridDisplay(false);
setO1MinorGridDisplay(false);
setAxisAssignment(0,0);
setAxisAssignment(1,0);
setAxisAssignment(2,0);
setY1LabelDisplay(true);
setY1AxisSide(0);
setTitleString("Risk Return Charting");
setY1MajorGridDisplay(false);
setY1MinorGridDisplay(false);
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getY1Label(),"#.##");
setPieFeelerTextDisplay(1);
setPieLabelDisplay(0);
setTextFormatPreset(getPieSliceLabel(),1);
setLegendDisplay(true);
setLegendReverse(true);
setFontName(getLegendText(),"Serif");
setFontSizeAbsolute(getLegendText(),true);
setFontSizeAbsolute(getY1Title(),true);
setFontSizeAbsolute(getY1Label(),true);
setFontSizeAbsolute(getY2Title(),true);
setFontSizeAbsolute(getY2Label(),true);
setFontSizeAbsolute(getO1Title(),true);
setDisplay(getX1MajorGrid(),false);
setDisplay(getY1MajorGrid(),false);
setDataTextTemplateBubble("<[Y]/[X]>");
setDataTextDisplay (true);
ENDSTYLE
ON GRAPH SET STYLE *
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
$
TYPE=DATA,
COLUMN=N2,
COLOR=RGB(140 175 239),
$
ENDSTYLE
END
Thanks
Cnu
WF 8.0.0.9 Database : oracle
CURRENT:
WebFOCUS 8.0.0.9 /oracle 11 i