Percentage Graph values
Percentage Graph values
(OP)
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
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
RE: Percentage Graph values
RE: Percentage Graph values
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%
RE: Percentage Graph values
RE: Percentage Graph values
setStackedDataValueSum(false);
With release 7.6.1, it will work with percentages, as well.
RE: Percentage Graph values