×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Percentage Graph values

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

RE: Percentage Graph values

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?

RE: Percentage Graph values

(OP)
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%

RE: Percentage Graph values

(OP)
You are correct, They are all different fields

RE: Percentage Graph values

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.

RE: Percentage Graph values

(OP)
Thank you

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close