Excel chart with OLE

[Former Member]

Dear experts,

I am using OLE to automate data into Excel chart. My problem now is i would like to change the font size in chart area at X and Y axis. What method and property should i use in order to change the size of the font in chart area?

Thanks in advance.

Simonksh

[Former Member]

Dear experts,

I am using OLE to automate data into Excel chart. My problem now is i would like to change the font size in chart area at X and Y axis. What method and property should i use in order to change the size of the font in chart area?

Thanks in advance.

Simonksh

[Former Member]

Hi,

To know the method and property,

- U can start recording a Macro and then

- Try changing the font size at x and y axis.

- Then stop recording the Macro.

- Go to that Macro in Edit Mode and see the code, U can figure out the Method & Property.

-Satya Priya

[Former Member]

Hi,

U can use the following method & property.

Selection.Font.Size = 20

-Satya Priya

[Former Member]

Hi,

How to convert the code into ABAP?

Thanks.

Simonksh