Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
claude_jakob
Contributor III
Contributor III

Export chart data to Excel to create graphs

Hi

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.

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.

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.

Thanks for any suggestions.
Claude

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/4276.Chart_5F00_Export.xls:550:0]

0 Replies