Focal Point
[SOLVED] Graph Y axis in ##.## Format

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

November 08, 2011, 01:13 AM
Sivashankari Venkataraman
[SOLVED] Graph Y axis in ##.## Format
I am trying to create a graph with Y axis label format ##.## (i.e for example i need values like 01.00 , 02.50 , 03.00 etc). Please find the code below. When i execute the graph code i do not get the desired ##.## format in Y axis.I have also attached the imgae which i get after executing the code.


DEFINE FILE CAR
SE/D12=IF CAR EQ 'AUDI' THEN 825 ELSE IF CAR EQ 'BMW' THEN 500 ELSE 300;
DIV/I11 = SE/60;
REM/D12.2 = DIV + (IMOD(SE,60,'D12'))/100;
SIL/D12.2 = REM-1.2;
END

GRAPH FILE CAR
-* Created by Advanced Graph Assistant
SUM CAR.COMP.REM/D12.2
CAR.COMP.SIL/D12.2
BY CAR.COMP.CAR
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET VZERO ON
ON GRAPH SET HAXIS 770
ON GRAPH SET VAXIS 405
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH VBRSTK1
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D OFF
ON GRAPH SET GRID ON
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET GRAPHSTYLE *
setReportParsingErrors(false);
setSelectionEnableMove(false);
setDepthRadius(5);
setTransparentBorderColor(getChartBackground(),true);
setMarkerDisplay(true);
setConnectLineMarkers(false);
setConnectScatterMarkers(false);
setO1LabelDisplay(true);
setO1AxisSide(0);
setO1MajorGridDisplay(true);
setO1MajorGridStyle(0);
setO1MinorGridDisplay(false);
setY1LabelDisplay(true);
setY1AxisSide(0);
setY1MajorGridDisplay(true);
setY1MajorGridStyle(0);
setY1MinorGridDisplay(false);
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getY1Label(),"##.##");
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);
setDisplay(getDataText(),true);
ENDSTYLE
END

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


Webfocus 7702
Unix
All outputs
November 08, 2011, 02:32 AM
Ramkumar - Webfous
Hi,

This seems to be an issue/limitation with the tool.

With this piece

  
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getY1Label(),"##.##");


This should work perfect, where in It is not.

There was already an topic discussed on the same issue, which is marked solved. But pity, without any solution.

http://forums.informationbuild...957027006#1957027006

You may raise this to Tech Support, to get this further.


Thanks,

Ramkumar.
WebFOCUS/Tableau
Webfocus 8 / 7.7.02
Unix, Windows
HTML/PDF/EXCEL/AHTML/XML/HTML5
November 08, 2011, 07:46 AM
Tom Flynn
setTextFormatPattern(getY1Label(),"00.00");


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
November 08, 2011, 08:07 AM
Sivashankari Venkataraman
Thanks Tom, setTextFormatPattern(getY1Label(),"00.00");
works fine.

Thanks Ramkumar for your input.


Webfocus 7702
Unix
All outputs