topic Re: How to enable data tips for graph in ods excel in ODS and Base Reporting

How to enable data tips for graph in ods excel

vikaskubde — Thu, 01 Nov 2018 14:12:06 GMT

Re: How to enable data tips for graph in ods excel

vikaskubde — Thu, 01 Nov 2018 14:16:10 GMT

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

Re: How to enable data tips for graph in ods excel

RW9 — Thu, 01 Nov 2018 14:19:09 GMT

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.

Re: How to enable data tips for graph in ods excel

vikaskubde — Thu, 01 Nov 2018 14:26:32 GMT

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

Re: How to enable data tips for graph in ods excel

vikaskubde — Thu, 01 Nov 2018 14:38:19 GMT

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.

Re: How to enable data tips for graph in ods excel

RW9 — Thu, 01 Nov 2018 15:12:55 GMT

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

Re: How to enable data tips for graph in ods excel

vikaskubde — Thu, 01 Nov 2018 18:49:45 GMT

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

Re: How to enable data tips for graph in ods excel

RW9 — Fri, 02 Nov 2018 08:47:45 GMT

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

Re: How to enable data tips for graph in ods excel

vikaskubde — Fri, 02 Nov 2018 14:49:03 GMT

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

Thanks,
Vikas