Export graph to excel

[nareshthavidishetty]

Hi,

We were facing an issue like,

The user wants to export graphs(bar..) in excel , but when they click on export to excel button they get tables.

Please let me know how to export an graph directly into excel.

Thanks..

[Anonymous]

Hi,

As far as I know, you can only export values of a graph to Excel.

Why would you want to export a graph to Excel ? 

[awhitfield]

Sorry, that's not supported!

[Anonymous]

What you could do is, right-click on the object, from the pop-up menu choose 'Copy to clipboard' -> 'Object' and then paste this in Excel.

[nareshthavidishetty]

Hi,

It should be automated with qlikview selection but not manual copy and paste.

Any other way to get this..

Thanks..

[nareshthavidishetty]

Hi,

Any suggestions.

Thanks..

[tyagishaila]

you have to use macro for this.

[tyagishaila]

Go to attachment,

This is the perfect solution of your problem,

[#9]

Hi

You can get this by right click on Bar Chart and then go to Copy to Clipboard then select Image. After that paste it in Excel.

Hope this help you,

[avinashelite]

You need to make use of the macro to achieve this, check this threads

Qlikview to excel export macro

Macro export to excel