I am trying to export sas graphs to excel sheet by using ods and proc gplot.
when i ran the code, the graph is pasted into the excel but which is not visible at all(PNG format). BY default graph is pasted in some other location.
Can you please tell me the way to export graph to excel sheet?
It would be useful to see your ALL your code. When you use ODS, you are not directly doing an "export" of SAS/GRAPH output to Excel. ODS HTML (or other HTML-based destinations) are creating an ASCII text file with HTML tags, that Excel knows how to open and render.
Depending on the device driver you use (JPEG vs GIF vs ACTIVEX) in your DEVICE= option, Excel may treat your image in a different fashion when the HTML file is opened with Excel.
If you are using ODS TAGSETS.EXCELXP, you should see a note in the SAS log that says:
Excel XML does not support output from Proc:Gchart
Output will not be created.
Can you share your code, including your options, goptions, ODS statements, etc??