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

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

Tue, 19 May 2009 16:02:17 GMT

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

Tue, 19 May 2009 16:24:17 GMT

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

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

Tue, 19 May 2009 16:31:04 GMT

Thanks.

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

manishkumar75 — Tue, 19 May 2009 16:35:28 GMT

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