topic Force alignment on headings on chart for excel export in QlikView https://community.qlik.com/t5/QlikView/Force-alignment-on-headings-on-chart-for-excel-export/m-p/234019#M85509 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I'm trying to force a right alignment on headings on a pivot table. I've tried setting all the usual stuff for headings in the 'Presentation'-tab on the chart.</P><P>Label - Right<BR />Data(Numeric) - Right<BR />Data(Text) - Right</P><P>Excel does not seem to read these settings when you use the 'Sent to excel' button or when you do the normal export to a excel file.</P><P>Is there any workarounds? I've testing the export to both Excel 2003/2007 and it does not read these settings in either of them.<BR /><BR />Maybe I could force these settings in a Export Macro type? Any idea's would be appreciated.</P><P>Kind regards,<BR />Kjetil</P></BODY></HTML> Tue, 09 Feb 2010 11:27:18 GMT 2010-02-09T11:27:18Z Force alignment on headings on chart for excel export https://community.qlik.com/t5/QlikView/Force-alignment-on-headings-on-chart-for-excel-export/m-p/234019#M85509 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I'm trying to force a right alignment on headings on a pivot table. I've tried setting all the usual stuff for headings in the 'Presentation'-tab on the chart.</P><P>Label - Right<BR />Data(Numeric) - Right<BR />Data(Text) - Right</P><P>Excel does not seem to read these settings when you use the 'Sent to excel' button or when you do the normal export to a excel file.</P><P>Is there any workarounds? I've testing the export to both Excel 2003/2007 and it does not read these settings in either of them.<BR /><BR />Maybe I could force these settings in a Export Macro type? Any idea's would be appreciated.</P><P>Kind regards,<BR />Kjetil</P></BODY></HTML> Tue, 09 Feb 2010 11:27:18 GMT https://community.qlik.com/t5/QlikView/Force-alignment-on-headings-on-chart-for-excel-export/m-p/234019#M85509 2010-02-09T11:27:18Z Force alignment on headings on chart for excel export https://community.qlik.com/t5/QlikView/Force-alignment-on-headings-on-chart-for-excel-export/m-p/234020#M85510 <HTML><HEAD></HEAD><BODY><P>Could you please post a sample qvw here?</P></BODY></HTML> Tue, 09 Feb 2010 17:20:09 GMT https://community.qlik.com/t5/QlikView/Force-alignment-on-headings-on-chart-for-excel-export/m-p/234020#M85510 disqr_rm 2010-02-09T17:20:09Z