topic Macro drops Chart heading?! in QlikView https://community.qlik.com/t5/QlikView/Macro-drops-Chart-heading/m-p/427712#M159388 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a macro that exports charts to excel. When I export a chart as a Bitmap (obj.CopyBitmapToClipboard), its only exports the body of the graph and not the heading given.</P><P></P><P>Any Ideas?</P></BODY></HTML> Fri, 31 May 2013 07:59:53 GMT 2013-05-31T07:59:53Z Macro drops Chart heading?! https://community.qlik.com/t5/QlikView/Macro-drops-Chart-heading/m-p/427712#M159388 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have a macro that exports charts to excel. When I export a chart as a Bitmap (obj.CopyBitmapToClipboard), its only exports the body of the graph and not the heading given.</P><P></P><P>Any Ideas?</P></BODY></HTML> Fri, 31 May 2013 07:59:53 GMT https://community.qlik.com/t5/QlikView/Macro-drops-Chart-heading/m-p/427712#M159388 2013-05-31T07:59:53Z Re: Macro drops Chart heading?! https://community.qlik.com/t5/QlikView/Macro-drops-Chart-heading/m-p/427713#M159389 <HTML><HEAD></HEAD><BODY><P>Captions are not exported. You can try the macro from <A _jive_internal="true" href="https://community.qlik.com/message/137929#137929">this post</A>. Change <SPAN style="color: #737373; font-family: Arial; background-color: #f5f5f5;"> tableToExport.CopyTableToClipboard true</SPAN> with <SPAN style="color: #737373; font-family: Arial; background-color: #f5f5f5;"> tableToExport.CopyBitmapToClipboard true </SPAN>if you want to copy the image of the table instead of the data.</P></BODY></HTML> Fri, 31 May 2013 08:18:37 GMT https://community.qlik.com/t5/QlikView/Macro-drops-Chart-heading/m-p/427713#M159389 Gysbert_Wassenaar 2013-05-31T08:18:37Z