Need Help to create Graph like this :

This is the exact output required for my graph..

quote:

tinypic

This far I have reached...

TABLE FILE CAR
SUM
CAR.BODY.RETAIL_COST
CAR.BODY.DEALER_COST
COMPUTE PCTCHG/D12.2 = CAR.BODY.DEALER_COST + CAR.BODY.RETAIL_COST; AS 'TOTAL, OF RETAIL & DEALER'
COMPUTE XR/D12.2% = ( RETAIL_COST / PCTCHG ) * 100; AS '%RETAIL'
COMPUTE XD/D12.2% = ( DEALER_COST / PCTCHG ) * 100; AS '%DEALER'
BY LOWEST CAR.ORIGIN.COUNTRY
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE HOLD AS DEMODATA FORMAT ALPHA
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
ENDSTYLE
END
-*Do not delete or modify the comments below
*-INTERNAL_COMMENT LINE#0$CjxSb290IHZlcnNpb249IjEuMCIgPgogICA8T2JqZWN0IG9iamVjdElkPSJHTE9CQUwiID4KICAgICAgPFByb3BlcnR5IG5hbWU9IlNhbXBsZURhdGEiIHR5cGU9ImphdmEubGFuZy5Cb29sZWFuIiA+ZmFsc2U8L1Byb3BlcnR5PgogICAgICA8UHJvcGVydHkgbmFtZT0iR2xvYmFsUmVjb3JkTGltaXQiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID41MDA8L1Byb3BlcnR5PgogICAgICA8UHJvcGVydHkgbmFtZT0iR2xvYmFsUnVuUmVjb3JkTGltaXQiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID4wPC9Qcm9wZXJ0eT4KICAgICAgPFByb3BlcnR5IG5hbWU9ImZpZWxkRGlzcGxheU1vZGUiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID5sYWJlbDwvUHJvcGVydHk+CiAgICAgIDxQcm9wZXJ0eSBuYW1lPSJwcmVmaXhEaXNwbGF5TW9kZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPjwvUHJvcGVydHk+CiAgICAgIDxQcm9wZXJ0eSBuYW1lPSJlbmFibGVQcmV2aWV3IiB0eXBlPSJqYXZhLmxhbmcuQm9vbGVhbiIgPnRydWU8L1Byb3BlcnR5PgogICAgICA8UHJvcGVydHkgbmFtZT0iRm9jZXhlY1ByZWZlcmVuY2VzIiB0eXBlPSJNYXAiID4KICAgICAgICAgPEVudHJ5IGtleT0iZGVmYXVsdF90YWJsZV9mb3JtYXQiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID5IVE1MPC9FbnRyeT4KICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheUVkaXRNb2RlSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+ZmFsc2U8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5Rm9ybWF0VGFiSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+dHJ1ZTwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlIb21lVGFiSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+ZmFsc2U8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5UXVpY2tBY2Nlc3NUb29sYmFyU2F2ZUluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPnRydWU8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5UmVzb3VyY2VzRmllbGRUYWJJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID5mYWxzZTwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRlZmF1bHRfY2hhcnRfZm9ybWF0IiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+SFRNTDwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlJbnNlcnRUYWJJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID5mYWxzZTwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlTbGljZXJzVGFiRWRpdEluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPmZhbHNlPC9FbnRyeT4KICAgICAgICAgPEVudHJ5IGtleT0iZGlzcGxheVNlcmllc1RhYkluZm9NaW5pUHJlZmVyZW5jZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPmZhbHNlPC9FbnRyeT4KICAgICAgICAgPEVudHJ5IGtleT0iaW5mb0Fzc2lzdE1vZGVBbGxvd2VkSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+ZmFsc2U8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkZWZhdWx0X3ByZXZpZXdfcGFnZWxpbWl0X2xheW91dCIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPjE8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJleGNlbF9mb3JtYXRfdmlzaWJsZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPnRydWU8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkZWZhdWx0X3ByZXZpZXdfcGFnZWxpbWl0IiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+NTwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRlZmF1bHRfY29tcG9zZV9mb3JtYXQiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID5QREY8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5SW50ZXJhY3RpdmVNb2RlSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+dHJ1ZTwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlEYXRhVGFiSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+ZmFsc2U8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJlZGl0b3JUeXBlX3Zpc2libGUiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID50cnVlPC9FbnRyeT4KICAgICAgICAgPEVudHJ5IGtleT0idGhlbWVzX2NvbnRyb2xfdmlzaWJsZSIgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPnRydWU8L0VudHJ5PgogICAgICAgICA8RW50cnkga2V5PSJkaXNwbGF5U2xpY2Vyc1RhYkludGVyYWN0aXZlSW5mb01pbmlQcmVmZXJlbmNlIiB0eXBlPSJqYXZhLmxhbmcuU3RyaW5nIiA+dHJ1ZTwvRW50cnk+CiAgICAgICAgIDxFbnRyeSBrZXk9ImRpc3BsYXlMYXlvdXRUYWJJbmZvTWluaVByZWZlcmVuY2UiIHR5cGU9ImphdmEubGFuZy5TdHJpbmciID5mYWxzZTwvRW50cnk+CiAgICAgIDwvUHJvcGVydHk+CiAgICAgIDxQcm9wZXJ0eSBuYW1lPSJjYXNjYWRlTmFtZXMiIHR5cGU9Ik1hcCIgPjwvUHJvcGVydHk+CiAgICAgIDxQcm9wZXJ0eSBuYW1lPSJNYXN0ZXJfRmlsZXMiIHR5cGU9IlNldCIgPgogICAgICAgICA8RW50cnkgdHlwZT0iamF2YS5sYW5nLlN0cmluZyIgPkRFTU9EQVRBPC9FbnRyeT4KICAgICAgPC9Qcm9wZXJ0eT4KICAgPC9PYmplY3Q+CjwvUm9vdD4=
-*Do not delete or modify the comments above
GRAPH FILE DEMODATA
-* Created by Advanced Graph Assistant
SUM DEMODATA.DEMODATA.DEALER_COST
DEMODATA.DEMODATA.RETAIL_COST
BY DEMODATA.DEMODATA.COUNTRY
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET VZERO OFF
ON GRAPH SET HAXIS 770
ON GRAPH SET VAXIS 405
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH HBRSTK1
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 1
ON GRAPH SET GRAPHSTYLE *
setTemplateFile("/images/tdg/template/IBISouthWestern.txt");
setReportParsingErrors(false);
setSelectionEnableMove(false);
setTransparentBorderColor(getSeries(0),true);
setTransparentBorderColor(getSeries(1),true);
setTransparentBorderColor(getSeries(2),true);
setTransparentBorderColor(getSeries(3),true);
setTransparentBorderColor(getSeries(4),true);
setTransparentBorderColor(getSeries(5),true);
setTransparentBorderColor(getSeries(6),true);
setTransparentBorderColor(getSeries(7),true);
setTransparentBorderColor(getSeries(8),true);
setTransparentBorderColor(getSeries(9),true);
setTransparentBorderColor(getSeries(10),true);
setDepthRadius(5);
setTransparentBorderColor(getChartBackground(),true);
setPlace(true);
ENDSTYLE
END

Now need help to Put %values as DATALABEL...

This message has been edited. Last edited by: webFocus_reporter,

I believe that someone else had a similar issue, have you searched the forum ?

Its was an issue with adding a % to the values.

That was me .. I did post this again as i did not get any help.

You can add this to the graph style, but it only gives you the individual values.

setDataTextFormat(2);
setDataTextDisplay(true);

There may be other format types that will do what you want, but you will have to check the documentation.

Thanks Waz..
Since it is a Stacked graph, I do not see other Fromat for this graph. Actually my Client is creating this graph manually in EXCEL and their argument is regarding WebFocus capabilities to handle this type of graphs.

Anyway WAZ that was great help.