topic Re: exporting chart from access point to excel in QlikView

exporting chart from access point to excel

rcorcoran — Mon, 26 Jan 2026 18:19:17 GMT

How can I export chart in access point to excel. I have tried the copy and paste special but it doesn't work. Really annoying our users

I have the export to excel option but it will not export the chart as a bar or line chart etc only as a table

Any help appreciated

Re: exporting chart from access point to excel

Thu, 05 Mar 2015 14:56:40 GMT

You need to insert in the caption of the object the "send to XL file" button. So you just press this button and the table goes to excel.

Re: exporting chart from access point to excel

awhitfield — Thu, 05 Mar 2015 14:58:36 GMT

Caption Tab > Special Icons > Send to Excel

Adny

Re: exporting chart from access point to excel

rcorcoran — Thu, 05 Mar 2015 15:00:20 GMT

Thanks but this only exports a bar or line chart as text I want the actual chart to show

Rhona

Re: exporting chart from access point to excel

chrislofthouse — Thu, 05 Mar 2015 15:00:46 GMT

Renato is correct, however this will export as a table not a visual. You have to select the 'copy to clipboard' option for the image. Also make sure these features are permitted by the QMC.

Re: exporting chart from access point to excel

rcorcoran — Thu, 05 Mar 2015 15:00:56 GMT

Thanks but this only exports the data I want a bar or line chart to export as a chart

Rhona

Re: exporting chart from access point to excel

awhitfield — Thu, 05 Mar 2015 15:06:19 GMT

Enable 'copy Image to ClipBoard'

Re: exporting chart from access point to excel

rcorcoran — Thu, 05 Mar 2015 15:06:20 GMT

I don’t have the copy to clipboard option in access point. Where in the QMCdo I need to allow this

Thanks again

Re: exporting chart from access point to excel

rcorcoran — Thu, 05 Mar 2015 15:08:08 GMT

Ok print and export to excel are enabled for all users in the QMC but not working

Rhona

Re: exporting chart from access point to excel

awhitfield — Thu, 05 Mar 2015 15:10:22 GMT

You need to enable it in the actual QVW, PLUS you need be opening the dashboard via IE, using the IE Plugin Option, it's doesn't appear to be available in the Full Browser (AJAK Client)

Andy

Re: exporting chart from access point to excel

chrislofthouse — Thu, 05 Mar 2015 15:13:51 GMT

This is on an individual chart basis, under caption in the chart properties.

Re: exporting chart from access point to excel

awhitfield — Thu, 05 Mar 2015 15:14:16 GMT

So, are you opening the dashboard using the IE Plugin OR Full Browser Version, in the Access Point?

Re: exporting chart from access point to excel

rcorcoran — Thu, 05 Mar 2015 15:21:20 GMT

Not sure I have to go to meeting will reply to these later thanks for all your help

Re: exporting chart from access point to excel

rcorcoran — Wed, 18 Mar 2015 08:35:58 GMT

I am using access point in full browser and found the solution to this to be:

Right click on chart and select print. this will open chart in a separate window. Right click and copy. Paste special into excel as bitmap