Skip to Content
0
Former Member
Jun 10, 2009 at 06:30 PM

Excel OLE PlotBy

45 Views

Hi,

I'm creating a chart in Excel from ABAP.

My problem is, that I want to change the series to columns (swapping the axis). As far as I know this can be done i VBA with the statement PlotBy:=xlColumns.

In my ABAP I have the following code (after setting the range):

CALL METHOD OF chart 'SetSourceData' EXPORTING #1 = range #2 = 1.

Can I somehow add the PlotBy, so I can swop the axis?

Regards,

Vibeke