I need to create a Merged Graph with advanced graphic, use series-legend and sort the X axis with store order, but only display X axis with store name not the store order. Here I use GGSALE database to describe my requirement. I join GGSALE to GGSTORE to have Store name and STORE code, use Dollars as Y axis, and Store Code as X and add Category as Series-legend. I need to show sale of each category for each store. I need to sort the X axis with the order of store-code, but only display store-name not the sore code. But I got error. When I try to do
ACROSS SALEHOLD.SALEHOLD.STCD NOPRINT
ACROSS J0.STORES01.STORE_NAME
Here is the code which only show store-code not the store nsme.
**********
JOIN
GGSALES.SALES01.STCD IN GGSALES TO UNIQUE GGSTORES.STORES01.STORE_CODE
IN GGSTORES TAG J0 AS J0
END
TABLE FILE GGSALES
SUM
'GGSALES.SALES01.DOLLARS'
BY 'GGSALES.SALES01.STCD'
BY 'J0.STORES01.STORE_NAME'
BY 'GGSALES.SALES01.CATEGORY'
ON TABLE HOLD AS SALEHOLD

GRAPH FILE SALEHOLD
-* Created by Advanced Graph Assistant
SUM SALEHOLD.SALEHOLD.DOLLARS
BY SALEHOLD.SALEHOLD.CATEGORY
ACROSS SALEHOLD.SALEHOLD.STCD
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET VZERO OFF
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET HAXIS 770
ON GRAPH SET VAXIS 405
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 1
ON GRAPH SET GRXAXIS 1
ON GRAPH SET GRAPHSTYLE *

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

Hi Emily, Could you post the complete code ( within the code delimiters, shown in the above tool bar as < / > )

Thanks, Douglas Lee

Is this anywhere near what your looking for:

JOIN
GGSALES.SALES01.STCD IN GGSALES TO UNIQUE GGSTORES.STORES01.STORE_CODE
IN GGSTORES TAG J0 AS J0
END
GRAPH FILE GGSALES
SUM GGSALES.SALES01.DOLLARS
ACROSS GGSALES.SALES01.STCD
BY GGSALES.SALES01.CATEGORY
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 SET GRMERGE 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);
setY1LabelDisplay(true);
setY1AxisSide(0);
setY1MajorGridDisplay(true);
setY1MajorGridStyle(0);
setY1MinorGridDisplay(false);
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getY1Label(),"#.##");
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 *
SQUEEZE=ON, ORIENTATION=PORTRAIT,$
TYPE=REPORT, GRID=OFF, FONT='ARIAL', SIZE=10,$
ENDSTYLE
END

-Doug

Doug,
The graphic in
"Webfocus online help -> Creating Graphs With Advanced Graph Assistant ->
Creating Multiple Graphs With Advanced Merge ->
Procedure: How to Create a Merged Graph " is closed to what I need. But further more, the X lable should sorted by code number, but display X label with name.
Here is my code: *******

JOIN
GGSALES.SALES01.STCD IN GGSALES TO UNIQUE GGSTORES.STORES01.STORE_CODE
IN GGSTORES TAG J0 AS J0
END
TABLE FILE GGSALES
SUM
'GGSALES.SALES01.DOLLARS'
BY 'GGSALES.SALES01.STCD'
BY 'J0.STORES01.STORE_NAME'
BY 'GGSALES.SALES01.CATEGORY'
ON TABLE HOLD AS SALEHOLD
END

GRAPH FILE SALEHOLD
-* Created by Advanced Graph Assistant
SUM SALEHOLD.SALEHOLD.DOLLARS
BY SALEHOLD.SALEHOLD.CATEGORY
ACROSS SALEHOLD.SALEHOLD.STCD
ON GRAPH PCHOLD FORMAT PNG
ON GRAPH SET GRAPHDEFAULT OFF
ON GRAPH SET VZERO OFF
ON GRAPH SET HTMLENCODE ON
ON GRAPH SET HAXIS 770
ON GRAPH SET VAXIS 405
ON GRAPH SET UNITS PIXELS
ON GRAPH SET LOOKGRAPH VBAR
ON GRAPH SET GRMERGE ADVANCED
ON GRAPH SET GRMULTIGRAPH 0
ON GRAPH SET GRLEGEND 1
ON GRAPH SET GRXAXIS 1
ON GRAPH SET GRAPHSTYLE *
setTemplateFile("/images/tdg/template/IBISouthWestern.txt");
setReportParsingErrors(false);
setSelectionEnableMove(false);
setDepthRadius(5);
setTransparentBorderColor(getChartBackground(),true);
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);
setPlace(true);
ENDSTYLE
END

I was thinking along the lines of adding
"ACROSS SALEHOLD.SALEHOLD.STORE_NAME"
after
"ACROSS SALEHOLD.SALEHOLD.STCD"
And changing the 1 to 2 in
"ON GRAPH SET GRLEGEND 1"

But, that's not doing it.

Anyone Else have a solution?