Hi,
I'm trying to build a graph (Vertical Bar) against percentage, somewhat I'm not able to show the % sign with data.

This is the sample code,

TABLE FILE CAR
SUM RETAIL_COST
BY COUNTRY
ON TABLE HOLD AS TEST
END

SET LOOKGRAPH=VBAR
-*SET BARNUM = ON
SET GRID=OFF
SET 3D=OFF
SET VZERO=OFF
SET HAXIS=888
SET VAXIS=440

SET GRAPHEDIT = SERVER

GRAPH FILE TEST
SUM
COMPUTE TT/I3%=((RETAIL_COST / TOT.RETAIL_COST) * 100);
ACROSS COUNTRY
ON GRAPH SET GRAPHSTYLE *
setO1TitleString("This is Ordinal(O1) axis title");
setO1TitleDisplay(true);
setO1TitleAutofit(false);

setTitleDisplay(true);
setTitleString("test graph");
setTitleAutofit(true);

setFontSizeAbsolute(true);
setFontName(getSubtitle(),"Courier");
setFontName(getTitle(),"TimesRoman");
setFontSizeInPoints(getY1Label(),50);
setFontSizeVC(getO1Label(),2000);

setTextRotation(getDataText(),1);
setTextJustHoriz(getDataText(),0);
setDataTextDisplay(true);
-*setDataTextFormat(2);
-*setDataTextFormatPattern("#.##");

ENDSTYLE
END
-EXIT

I want the column TT should show as 100% but when I set the DataTextFormat property to 2, it shows as 10,000%. Please let me know if we have any other property to show the percentage.

Thanks in advance,

I have this (less than vague) feeling that when you use the % symbol in GRAPH, it behaves differently than if you used it in TABLE - do not multiply by 100 in GRAPH.

It doesn't make any sense, but I think I discovered this behaviour a year ago.

For a related problem, I opened case 12722036 - regarding use of % and Excel 2000 issues.

This message has been edited. Last edited by: Francis Mariani,

You could try playing with this

setTextFormatPattern(getDataText(),"####%")

Tried that, not much luck.

I'm trying with setY1LabelFormat now.