I read a lot of post about this subject on this forum and I still can't get the graph in excel.

Here is my test procedure

  
APP HOLD BASEAPP
GRAPH FILE CAR
SUM DCOST
    RCOST
BY COUNTRY
ON GRAPH SET GRAPHEDIT OFF
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO OFF
ON GRAPH SET GRID ON
ON GRAPH SET GRMERGE ON
ON GRAPH SET HAXIS 600
ON GRAPH SET VAXIS 400
ON GRAPH SET GRAPHSTYLE *
setCustomDataText(getY1Label(), true);
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getY1Label(),"#,###,###");
ENDSTYLE
ON TABLE HOLD AS mygraph FORMAT JPEG
END
DEFINE FILE CAR
  GRAPH/A100 = '<IMG SRC=mygraph.jpeg>';
END
TABLE FILE CAR
BY COUNTRY NOPRINT
IF RECORDLIMIT EQ 1
FOOTING
"<GRAPH"
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K
END

When I run it, mygraph.jpeg is correctly generated in baseapp directory but the image is not displayed in excel and I don't understand why.
SET GRAPHENGINE=GRAPH53
-INCLUDE sauvegarder_un_graphe.fex
-* File sauvegarder_un_graphe.fex
APP HOLD BASEAPP
GRAPH FILE CAR
SUM DCOST
RCOST
BY COUNTRY
ON GRAPH SET GRAPHEDIT OFF
ON GRAPH SET BARNUMB OFF
ON GRAPH SET 3D OFF
ON GRAPH SET VZERO OFF
ON GRAPH SET GRID ON
ON GRAPH SET GRMERGE ON
ON GRAPH SET HAXIS 600
ON GRAPH SET VAXIS 400
ON GRAPH SET GRAPHSTYLE *
setCustomDataText(getY1Label(), true);
setTextFormatPreset(getY1Label(),-1);
setTextFormatPattern(getY1Label(),"#,###,###");
ENDSTYLE
ON TABLE HOLD AS mygraph FORMAT JPEG
END
DEFINE FILE CAR
GRAPH/A100 = ' ';
END
TABLE FILE CAR
BY COUNTRY NOPRINT
IF RECORDLIMIT EQ 1
FOOTING
"<GRAPH"
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT EXL2K
END
0 NOMBRE D'ENREGISTREMENTS DANS LE GRAPHIQUE=       18  POINTS=      5
JPEG FICHIER ENREGISTRE ...
0(INF32080) NOMBRE D ENREGISTREMENTS DANS LA TABLE=        1  LIGNES=      1
WebFOCUS Version 7.6.7 compiled and linked on Fri Dec  5 13:52:42 EST 2008 (Gen branch767_hotfix:17)

In my configuration, the server is intalled on OS400 in the IFS (location : \home\iadmin\ibi\apps\baseapp)
The client is installed on a windows 2000 server (location : G:\ib_prd\ibi\WebFOCUS76)

Where should I generate the .jpeg (or .gif, ...) to be able to have it in excel ? (I made a lot of tests but I still can't have the graph in the excel sheet).

Thanks for your help.
Catherine

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

First why do you have the Graph Engine set to this?

SET GRAPHENGINE=GRAPH53


Can you go to BASEAPP
app and see the Graph open it in Paint or something?

(FOC32422) VALID VALUES ARE GRAPHENGINE=GRAPH53, GRAPH32, NEW, OR OLD

  IMAGE/A200='<img src=http://yoursever/approot/sys_folder/graphfilex.gif>';[