Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Percentage Graph values

Status
Not open for further replies.

floydome

Technical User
Feb 27, 2007
9
US
Hi, I am trying to run a percentage graph. This is the scenario.
A = 2, B = 3 and C = 5.
The percent graph that i plotted shows the value 20% after A, 50% after B and 100% after C.
I basically want the actual values to be Displayed .ie A = 20%, B= 30% and C= 50%.
This might be an easy fix but i have tried my best but couldn't find a solution. I know that it is possible in Excel.
I would really appreciate any help
Thanks
 
I'm assuming that A, B and C are different fields, not different values of the same field. Correct? Could you post your request, so we can see what is happening?
 
GRAPH FILE FMTL_2
SUM SUPERVISOR_CU AS 'Consistent Use' SUPERVISOR_IU AS 'Inconsistent Use' SUPERVISOR_NT
AS 'Not Trained'
BY DISTRICT
BY LOCATION2 AS 'LOCATION'
HEADING
"District <DISTRICT - Supervisory Training "
ON GRAPH SET LOOKGRAPH HBRSTKPC
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB ON
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH SET GRWIDTH 0
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET GRAPHSTYLE *
setMarkerDisplay(true);
setConnectLineMarkers(true);
setConnectScatterMarkers(true);
setO1LabelDisplay(true);
setO1AxisSide(0);
setO1MajorGridDisplay(true);
setO1MajorGridStyle(0);
setO1MinorGridDisplay(false);
setAxisAssignment(0,0);
setSeriesType(0,3);
setAxisAssignment(1,0);
setSeriesType(1,1);
setAxisAssignment(2,0);
setSeriesType(2,1);
setY1LabelDisplay(true);
setY1AxisSide(0);
setY1MajorGridDisplay(true);
setY1MajorGridStyle(0);
setY1MinorGridDisplay(false);
setTextFormatPreset(getY1Label(),2);
setPieFeelerTextDisplay(1);
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);
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,
$
TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
COLOR='BLACK',
STYLE=BOLD,
$
TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=2,
COLOR='BLACK',
STYLE=BOLD,
$
TYPE=HEADING,
LINE=1,
OBJECT=FIELD,
ITEM=1,
COLOR='BLACK',
STYLE=BOLD,
$
ENDSTYLE
END
--------------------------------------------------------
When i run the above request, this is what i come up with - The end of Consistent Use is 69%, the end of Inconsistent Use is 94% and the end of Not trained is 100%..Basically i just want the actual % to be displayed on the Bar. I.E Consistent use - 69%, Inconsistent Use - 25% and Not Trained - 6%
 
You are correct, They are all different fields
 
Unfortunately, what you want (individual percentages in a stacked bar) won't be available until release 7.6.1. In release 7.1.3, we added the capability to get individual values (NOT percentages) with the API setting:

setStackedDataValueSum(false);

With release 7.6.1, it will work with percentages, as well.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top