topic MACRO TO SET THE FONT OF CAPTION in Qlik Learning Discussions https://community.qlik.com/t5/Qlik-Learning-Discussions/MACRO-TO-SET-THE-FONT-OF-CAPTION/m-p/811116#M2677 <HTML><HEAD></HEAD><BODY><P><BR />hi can somebody please suggest the Macro to set the font of the Caption of a chart</P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">i have found the obj and then used the below code</SPAN></P><P></P><P></P><P class="MsoNormal" style="margin: 0in 0in 0pt; line-height: normal; mso-layout-grid-align: none;"><SPAN style="color: black; font-family: 'Courier New'; font-size: 9pt;">set prop= obj.GetProperties</SPAN></P><P><SPAN style="mso-bidi-language: AR-SA; mso-fareast-language: EN-US; line-height: 115%; color: black; font-size: 9pt; mso-ansi-language: EN-US; mso-fareast-theme-font: minor-latin; font-family: 'Courier New'; mso-fareast-font-family: Calibri;">set Capfnt= prop.GraphLayout.Frame.CaptionFont</SPAN> </P><P class="MsoNormal" style="margin: 0in 0in 0pt; line-height: normal; mso-layout-grid-align: none;"><SPAN style="color: black; font-family: 'Courier New'; font-size: 9pt;">Capfnt.FontName= "Segoe UI"</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> <SPAN style="color: black; line-height: 115%; font-family: 'Courier New'; font-size: 9pt; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA;">obj.SetProperties prop</SPAN></SPAN></P><P> </P><P><SPAN style="mso-bidi-language: AR-SA; mso-fareast-language: EN-US; line-height: 115%; color: black; font-size: 9pt; mso-ansi-language: EN-US; mso-fareast-theme-font: minor-latin; font-family: 'Courier New'; mso-fareast-font-family: Calibri;">i am getting an error on the last step saying type mismatch </SPAN></P><P><SPAN style="mso-bidi-language: AR-SA; mso-fareast-language: EN-US; line-height: 115%; color: black; font-size: 9pt; mso-ansi-language: EN-US; mso-fareast-theme-font: minor-latin; font-family: 'Courier New'; mso-fareast-font-family: Calibri;">please help </SPAN></P><P> </P></BODY></HTML> Fri, 02 Jan 2015 14:16:22 GMT 2015-01-02T14:16:22Z MACRO TO SET THE FONT OF CAPTION https://community.qlik.com/t5/Qlik-Learning-Discussions/MACRO-TO-SET-THE-FONT-OF-CAPTION/m-p/811116#M2677 <HTML><HEAD></HEAD><BODY><P><BR />hi can somebody please suggest the Macro to set the font of the Caption of a chart</P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;">i have found the obj and then used the below code</SPAN></P><P></P><P></P><P class="MsoNormal" style="margin: 0in 0in 0pt; line-height: normal; mso-layout-grid-align: none;"><SPAN style="color: black; font-family: 'Courier New'; font-size: 9pt;">set prop= obj.GetProperties</SPAN></P><P><SPAN style="mso-bidi-language: AR-SA; mso-fareast-language: EN-US; line-height: 115%; color: black; font-size: 9pt; mso-ansi-language: EN-US; mso-fareast-theme-font: minor-latin; font-family: 'Courier New'; mso-fareast-font-family: Calibri;">set Capfnt= prop.GraphLayout.Frame.CaptionFont</SPAN> </P><P class="MsoNormal" style="margin: 0in 0in 0pt; line-height: normal; mso-layout-grid-align: none;"><SPAN style="color: black; font-family: 'Courier New'; font-size: 9pt;">Capfnt.FontName= "Segoe UI"</SPAN></P><P><SPAN style="color: #000000; font-family: Times New Roman; font-size: 12pt;"> <SPAN style="color: black; line-height: 115%; font-family: 'Courier New'; font-size: 9pt; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA;">obj.SetProperties prop</SPAN></SPAN></P><P> </P><P><SPAN style="mso-bidi-language: AR-SA; mso-fareast-language: EN-US; line-height: 115%; color: black; font-size: 9pt; mso-ansi-language: EN-US; mso-fareast-theme-font: minor-latin; font-family: 'Courier New'; mso-fareast-font-family: Calibri;">i am getting an error on the last step saying type mismatch </SPAN></P><P><SPAN style="mso-bidi-language: AR-SA; mso-fareast-language: EN-US; line-height: 115%; color: black; font-size: 9pt; mso-ansi-language: EN-US; mso-fareast-theme-font: minor-latin; font-family: 'Courier New'; mso-fareast-font-family: Calibri;">please help </SPAN></P><P> </P></BODY></HTML> Fri, 02 Jan 2015 14:16:22 GMT https://community.qlik.com/t5/Qlik-Learning-Discussions/MACRO-TO-SET-THE-FONT-OF-CAPTION/m-p/811116#M2677 2015-01-02T14:16:22Z