Hello,
This is my code for EXL2K Data Visualization Graph Bar. I get report output without Data Visualization Bar in Column 4(only Data) in Excel spreadsheet.Can someone help?

TABLE FILE r10173
PRINT
*
ON TABLE SET STYLE *
TYPE=REPORT,GRID=OFF,$
TYPE=DATA,COLUMN=N4,$
-IF &VISCHECK EQ true THEN GOTO VISULDIS ELSE GOTO ASTYLNEW;
-VISULDIS
GRAPHTYPE=DATA,COLUMN=N4, $
GRAPHTYPE=DATA,COLUMN=N4,GRAPHCOLOR='RED',WHEN =N4 GE 60 ,$
-ASTYLNEW
ENDSTYLE
ON TABLE PCHOLD FORMAT EXL2K
END

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

Per the documentation, in the manual, in the Dev Studio documentation:

  
 To make HTML, PDF and PS reports more powerful, you can insert visual representations of
 selected data directly into the report output.
 These visual representations are in the form of vertical or horizontal bar graphs that make
 relationships and trends among data more obvious.

Not EXCEL...

A workaround to this is to hold the report as HTML, then return it as Excel.

TABLE FILE CAR
SUM SALES
BY COUNTRY
ON TABLE SAVE AS SAV_HTML FORMAT HTML
ON TABLE SET STYLE *
TYPE=REPORT,GRID=OFF,$
TYPE=DATA,COLUMN=N4,$
GRAPHTYPE=DATA,COLUMN=SALES, $
GRAPHTYPE=DATA,COLUMN=SALES,GRAPHCOLOR='RED',WHEN =SALES GE 60 ,$
ENDSTYLE
END
 
-RUN

SET HTMLFORMTYPE = XLS
-HTMLFORM SAV_HTML