topic Re: ALV graph using Excel in Application Development and Automation Discussions

ALV graph using Excel

Former Member — Sun, 02 Nov 2008 14:26:25 GMT

Hi,

I want to plot a graph in ALV . I am using set_table_for_first_table method. My internal table is dynamic. The graph that I want to plot will be time vs dates. Since the date columns are dynamic I guess I cant use the 'Graph_matrix_3d' as it has limited number of columns.

The better approach would be to pass this data to excel internally when the user clicks on the graph button and then plot a graph. I saw a blog on this on SDN but what I want to know is the names of the methods or sample code or any more clues . I will continue my search on this.

Appriciate your help!

Any other approach is also appriciated.

Thanks in advance

Edited by: Sam m on Nov 2, 2008 3:35 PM

Re: ALV graph using Excel

Former Member — Sun, 02 Nov 2008 14:37:53 GMT

Hi Sam,

You might be searching for the below site.

Hope this helps you.

Cheers!1

VEnk@

Re: ALV graph using Excel

Former Member — Sun, 02 Nov 2008 15:14:21 GMT

I have that link, I need more information. How to plot graph that has dynamic values on the X axis.

Re: ALV graph using Excel

Former Member — Mon, 03 Nov 2008 10:24:20 GMT

Any clues guys?

Re: ALV graph using Excel

Former Member — Mon, 03 Nov 2008 10:45:53 GMT

Hi Sam

Chek program in the below link

http://www.saptechnical.com/Tutorials/ABAP/Splitter/Demo.htm

Regards,

Abdur

Re: ALV graph using Excel

Former Member — Thu, 06 Nov 2008 16:33:06 GMT

I found that it can be done using OLE automation.