Hi,
Above is the image of the table and expected Horizontal Stacked Graph.

The code below doesn't give me the expected result.
It shows "TYPE_SORT" i.e. 1 2 3
Instead of CBO_PASTDUE, CBO_0-30 etc.. in the Legend

Please help.

Thanks

-************

GRAPH FILE DATA

SUM
VALUE
ACROSS CATEGORY
BY TYPE_SORT NOPRINT
BY TYPE

ON GRAPH PCHOLD FORMAT JSCHART
ON GRAPH SET GRID ON
ON GRAPH SET VZERO OFF
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET HAXIS &WF_STYLE_WIDTH
ON GRAPH SET VAXIS &WF_STYLE_HEIGHT
ON GRAPH SET GRMERGE ON
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 1
ON GRAPH SET GRXAXIS 1
ON GRAPH SET LOOKGRAPH HBRSTK1
....

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

Try changing

ON GRAPH SET GRLEGEND 1
ON GRAPH SET GRXAXIS 1

By either

ON GRAPH SET GRLEGEND 2
ON GRAPH SET GRXAXIS 0

Or

ON GRAPH SET GRLEGEND 0
ON GRAPH SET GRXAXIS 2

Not sure which one, you have to test and play with those SET.

Thanks..Tried those options but no change

At you using AppStudio ? Try using the Chart GUI tool to get a basic stacked Bar chart.


Let us know if this works.

Cheers,
Tamra Colangelo
IBI Focal Point Moderator

Tried using the Chart GUI.
I have type_sort AS NOPRINT but it still shows 1 2 3 in the legend instead of TYPE value (i.e. BIM, PastDue..)

Your best solution would be to create a HOLD file based on how you want the data sorted.
Then graph off the HOLD file - eliminating the BY TYPE_SORT NOPRINT

At this point the NOPRINT does not actually make the field invisible in a graph as it does in a report.

The programming group is actually working on this option for a future release.

Hope that helps.

Cheers,
Tamra Colangelo
IBI Focal Point Moderator

From what i know, currently, only two BY fields (BY or ACROSS or both) are supported while graphing.

Creating the sort data HOLD file and using it in graph does not solve the issue