topic Export chart data to Excel to create graphs in QlikView https://community.qlik.com/t5/QlikView/Export-chart-data-to-Excel-to-create-graphs/m-p/225393#M589251 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>when I extract data from a line chart with 2 or more lines (from QV) and copy/send that data to excel to re-do the graph, the exported data is in a format that cannot be handled easily. The export places x-axis information in one column, and all the line data in one and the same column.</P><P>Is there an easy way to export QV chart information to excel in the way that each line data is placed in a separate column. Is this a matter of QV settings, excel macros or expression definition within the chart? I tried exporting data from charts from various demo applications and all gave the same data presentation.</P><P>I appended one example (with data from a QV demo application) in the attached excel sheet. It shows the way QV inserts the data but also the way I would need the data.</P><P>Thanks for any suggestions.<BR />Claude</P><P>[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/4276.Chart_5F00_Export.xls:550:0]</P></BODY></HTML> Thu, 28 Jan 2010 14:42:02 GMT claude_jakob 2010-01-28T14:42:02Z Export chart data to Excel to create graphs https://community.qlik.com/t5/QlikView/Export-chart-data-to-Excel-to-create-graphs/m-p/225393#M589251 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>when I extract data from a line chart with 2 or more lines (from QV) and copy/send that data to excel to re-do the graph, the exported data is in a format that cannot be handled easily. The export places x-axis information in one column, and all the line data in one and the same column.</P><P>Is there an easy way to export QV chart information to excel in the way that each line data is placed in a separate column. Is this a matter of QV settings, excel macros or expression definition within the chart? I tried exporting data from charts from various demo applications and all gave the same data presentation.</P><P>I appended one example (with data from a QV demo application) in the attached excel sheet. It shows the way QV inserts the data but also the way I would need the data.</P><P>Thanks for any suggestions.<BR />Claude</P><P>[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/4276.Chart_5F00_Export.xls:550:0]</P></BODY></HTML> Thu, 28 Jan 2010 14:42:02 GMT https://community.qlik.com/t5/QlikView/Export-chart-data-to-Excel-to-create-graphs/m-p/225393#M589251 claude_jakob 2010-01-28T14:42:02Z