January 16, 2006, 09:36 AM
Cyril JoyChanging the 100% in graph to real percentage.
In the following example, how to make the percentage values to show the exact
values instead of showing as 100%?
GRAPH FILE CAR
SUM DEALER_COST RETAIL_COST
ACROSS COUNTRY
ON GRAPH SET LOOKGRAPH HBRSTKPC
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB ON
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO OFF
ON GRAPH SET GRID ON
ON GRAPH SET GRAPHSTYLE *
setStackedDataValueSum(true);
ENDSTYLE
END
Thanks for your help. I have WF710 studio.
January 17, 2006, 02:30 AM
MichaelI Think this is what you want.
GRAPH FILE CAR
SUM RPCT.CAR.BODY.DEALER_COST RPCT.CAR.BODY.RETAIL_COST
ACROSS CAR.ORIGIN.COUNTRY
ON GRAPH SET LOOKGRAPH HBAR
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB ON
ON GRAPH SET 3D OFF
ON GRAPH SET GRID ON
ON GRAPH SET GRAPHSTYLE *
setStackedDataValueSum(true);
ENDSTYLE
END
January 17, 2006, 03:29 AM
Tony AHi Cyril,
If you want horizontal stacked bars with values instead of percentages then use graphtype 25 -
setGraphType(25);
Tony
January 17, 2006, 06:17 AM
Cyril JoyActually I want the value to be displayed only as percentage.
For example, in the example, the first bar is showing 46% and 100%.
Instead of that I want the display as 46% and 54%.
Any clues?
January 17, 2006, 11:12 AM
Tony ACyril,
I don't think you can do that with a horizontal stacked percentage as, by it's very nature, it always accumulates the bar values for display.
However, you can always manipulate your data to give what you want -
GRAPH FILE CAR
SUM COMPUTE TOTAL_COST/D12.2 = DEALER_COST + RETAIL_COST; NOPRINT
COMPUTE DCOST_PCT/D7.2% = SUM.DCOST / SUM.TOTAL_COST * 100;
COMPUTE RCOST_PCT/D7.2% = SUM.RCOST / SUM.TOTAL_COST * 100;
ACROSS COUNTRY
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB ON
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO OFF
ON GRAPH SET GRID ON
ON GRAPH SET GRAPHSTYLE *
setGraphType(25);
setStackedDataValueSum(false);
ENDSTYLE
END
Just needs a tweek on the scale min and max plus the data label format etc.
Enjoy
T