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