Hi,
got a table(oracle) :

Date         Name   Qty
05/01/2008   A      2
             B      2
             E      3
05/02/2008   B      2
             C      1
             D      3

need a graph that looks like(stacked) :

7 | A
6 | A           C
5 | B           B
4 | B           B
3 | E           D
2 | E           D
1 | E           D
------------------------------
    05/01/2008  05/02/2008 

my code now :

GRAPH FILE XYZ
PRINT QTY
ACROSS DATE
WHERE YEAR LE CURRY AND MONTH LE CURRM;
WHERE MONTH EQ '05';
ON GRAPH SET LOOKGRAPH VBRSTK1
ON GRAPH SET GRAPHEDIT SERVER
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO ON
ON GRAPH SET GRID ON
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET GRAPHSTYLE *
setMarkerDisplay(true);
setConnectLineMarkers(false);
setConnectScatterMarkers(false);
setO1LabelDisplay(true);
setO1AxisSide(0);
setO1MajorGridDisplay(true);
setO1MajorGridStyle(0);
setO1MinorGridDisplay(false);
setAxisAssignment(0,0);
setSeriesType(0,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,
$
ENDSTYLE
END

keeps getting:

7 | Q
6 | Q           Q
5 | Q           Q
4 | Q           Q
3 | Q           Q
2 | Q           Q
1 | Q           Q 
---------------------------- 
    05/01/2008  05/02/2008

webFocus sum the qty and display it as one bar...

don't know what's wrong, help! Thanks ^ ^)b

The problem that you have is the graph needs to know about the Name data, and it should be in separate fields so it is represented as different series in the graph. Then the series can be stacked.

What you need to get the stack is

GRAPH FILE XYZ
SUM QTY_1
    QTY_2
    QTY_3
    QTY_4
ACROSS DATE

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

Thank for the quick reply,

how do I put the name data? Everytime I tried to put it in the Y Axis of the graph it came out cnt.customername

thanks much

Yuuta, I just updated my last post.

You need to have multiple columns, i.e. a column for each Name Value populated with the Names QTY value.

If there are a limited number of Names, create DEFINE.

NAME_A/I9 = IF NAME EQ 'A' THEN QTY ELSE 0;

etc.

Aaa, I see... tried using across but it doesn't worked ^ ^

Thank you again.

Yuuta,
In order to create the names dynamically use Dialogue Manager:

  
SET HOLDLIST=PRINTONLY
TABLE FILE XYZ
BY NAME
ON TABLE SAVE
END
-RUN
-SET &MAXNAMES=&LINES;
DEFINE FILE XYZ
-REPEAT #NAMES FOR &I FROM 1 TO &MAXNAMES;
-READ SAVE,&NAME
NAME&I / format_of_qty = IF NAME EQ '&NAME' THEN QTY ELSE 0;
-#NAMES
END
GRAPH FILE XYZ
SUM 
-REPEAT #COLS FOR &I FROM 1 TO &MAXNAMES;
NAME&I
-#COLS
ACROSS DATE
....
END

I think all you should need to do to your original code is add BY NAME (before the ACROSS) and add ON GRAPH SET GRMERGE ON
in your ON GRAPH statements.

Pat, thanks, I did think that you could do this with a set, but couldn't find it in a quick search.