How to enable data tips for graph in ods excel

[vikaskubde]

There is a graphics option "imagemap=on" for ods html.
However this option is not applicable with ods excel.

[RW9]

Perhaps start by posting some information?  What code have you done, test data, example output?  Is this an Excel functionality, if so you would likely need to enable it in Excel.  

From what I can gather from your post your talking about this type of thing:

http://support.sas.com/documentation/cdl/en/graphref/63022/HTML/default/viewer.htm#a002596129.htm

if so that only works with the html destination.  Certain functionlity is specific to the destination, html is not Excel, Excel is not PDF etc.

[vikaskubde]

Do we have any option to show the data tips on graph in SAS, after exporting a graph in excel using ods excel

[vikaskubde]

I have code like:
Ods excel file="d:/report.xlsx";
Proc split data=work.sorttemptablesorted;
Plot ib*week mn*week hm*week/ overlay
Grid vaxis=axis1 haxis=axis2 ;
Run;
Ods excel close;



In the result window it showing the related graph and data tips as well.

However, when I open the report.xlsx from destination, it is showing the graph but it is not showing the data tips over graph in excel.

[RW9]

The result window will be showing the HTML output from that.  Excel is not HTML and therefore does not have the HTML functionality.

[vikaskubde]

So you mean there is no option to enable data tips for graphs in ods excel.

[RW9]

I do not find anything on Excel providing functionality to have data tips, so no.

[vikaskubde]

Okay, please let me know once you find the solution.

Thanks,
Vikas