I have a stacked area chart that has 2 measure and line with the month as the X Axis. The line is a the target for each month which is .9 * the total so it is always below the total of the 2 stacked items. Here is ny issue the users want to have a data label that displays the percentage of measure 1 against the total, not the target #.

So, say measure 1 for Jan is 500 and measure 2 is 250 then ney want the datalabel for that month to be that show as '66%'. anyone have any idea of how this could be done.

Thanks
Scott
WF8x

This message has been edited. Last edited by: <Kathryn Henning>,

You can COMPUTE the 2 percent fields and then set the color of both of them to be transparent. You will then simply show the data labels for those 2 new COMPUTED fields. Here is an example using CAR file:

GRAPH FILE CAR
-* Created by Info Assist for Graph
SUM CAR.BODY.RETAIL_COST
COMPUTE rc_total/D12.2=CAR.BODY.RETAIL_COST/( CAR.BODY.RETAIL_COST + CAR.BODY.SALES ) ; AS ' '
CAR.BODY.SALES
COMPUTE sl_total/D12.2=CAR.BODY.SALES /( CAR.BODY.RETAIL_COST + CAR.BODY.SALES ) ; AS ' '
COMPUTE target/D12.2=( CAR.BODY.RETAIL_COST + CAR.BODY.SALES ) * .9;
BY CAR.ORIGIN.COUNTRY
WHERE CAR.ORIGIN.COUNTRY NE 'FRANCE';
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET ARGRAPHENGIN JSCHART
ON GRAPH SET VZERO OFF
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET LOOKGRAPH VAREASTK
ON GRAPH SET STYLE *
*GRAPH_SCRIPT

setPieDepth(0);
setPieTilt(0);
setDepthRadius(0);
setCurveFitEquationDisplay(false);
setPlace(true);

*END
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
*GRAPH_SCRIPT

setReportParsingErrors(false);
setSelectionEnableMove(false);
setStackedDataValueSum(false);
setFillColor(getSeries(1),new Color(255,255,255,0));
setFillColor(getSeries(3),new Color(255,255,255,0));
setDataTextDisplay(false);
setDisplay(getDataText(1), true);
setDisplay(getDataText(3), true);
setTextFormatPreset(getDataText(),2);
setDataTextPosition(2);
setSeriesType(0,0);
setSeriesType(1,0);
setSeriesType(2,0);
setSeriesType(3,0);
setSeriesType(4,2);
*END
ENDSTYLE
END

-RUN

You may wish to edit the post subject

quote:

Stacket Area Shart