How to change chart "window title" (caption) from macro?

[#1]

How to change chart "window title" (caption) from macro?

[#2 · Accepted solution]

Hello Artur,

Try this macro:

sub setChartTitle
 set chart = ActiveDocument.GetSheetObject("CH01")
 set p = chart.GetProperties
 p.GraphLayout.WindowTitle.v = "Title"
 chart.SetProperties p
end sub

regards Mark

[#3]

Thanks.

[manishkumar75]

Hi Artur,

You can use the following macro :-

Sub ChangeTitle
set chart = ActiveDocument.GetSheetObject("CH01")
set p = chart.GetProperties

p.GraphLayout.WindowTitle.v = "Hello"
chart.SetProperties p

End Sub

Regards,

- Manish