Changing the chart caption format through macro

[#1]

Hi All,

My requirement is this:

I want to change the caption background color,font etc of various objects through a macro or extension .

I tried this:

mbp.GraphLayout.Frame.ActiveBgColor.PrimaryCol.Col=RGB(1,1,1)

mbp.GraphLayout.Frame.Color.PrimaryCol.Col=RGB(1,1,1)

The macro does not throw any error while executing it with a button click.

But, there is no effect on the chart.

Kindly help me out !

Thanks,

Anju