topic How to export Line Chart data to Excel in readable format in QlikView https://community.qlik.com/t5/QlikView/How-to-export-Line-Chart-data-to-Excel-in-readable-format/m-p/225362#M77681 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>when I use export of a line chart showing 2 or more lines to clipboard/send-to-excel or other means my new table in excel is structured in a way I cannot easily rebuild the graph in excel. The reason is that the Qlikview export always export the x-axis data in one column and all y-axis data in one column.</P><P>How can I export the chart data that data from each line is exported to a separate column? Is this a matter of configuring in Qlikview or do I need makros?</P><P>I attached an example of the way data is exported to excel and the way I would need data in excel. Example taken from graph of one of the demo applications.</P><P>I greatly appreciate suggestions. Thanks,</P><P>Claude</P><P>[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/0451.Chart_5F00_Export.xls:550:0]</P></BODY></HTML> Thu, 28 Jan 2010 14:26:51 GMT claude_jakob 2010-01-28T14:26:51Z How to export Line Chart data to Excel in readable format https://community.qlik.com/t5/QlikView/How-to-export-Line-Chart-data-to-Excel-in-readable-format/m-p/225362#M77681 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>when I use export of a line chart showing 2 or more lines to clipboard/send-to-excel or other means my new table in excel is structured in a way I cannot easily rebuild the graph in excel. The reason is that the Qlikview export always export the x-axis data in one column and all y-axis data in one column.</P><P>How can I export the chart data that data from each line is exported to a separate column? Is this a matter of configuring in Qlikview or do I need makros?</P><P>I attached an example of the way data is exported to excel and the way I would need data in excel. Example taken from graph of one of the demo applications.</P><P>I greatly appreciate suggestions. Thanks,</P><P>Claude</P><P>[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/0451.Chart_5F00_Export.xls:550:0]</P></BODY></HTML> Thu, 28 Jan 2010 14:26:51 GMT https://community.qlik.com/t5/QlikView/How-to-export-Line-Chart-data-to-Excel-in-readable-format/m-p/225362#M77681 claude_jakob 2010-01-28T14:26:51Z