Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
rcorcoran
Creator
Creator

exporting chart from access point to excel

Hi

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

R

1 Solution

Accepted Solutions
rcorcoran
Creator
Creator
Author

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

View solution in original post

13 Replies
Not applicable

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.

send to xl.png

awhitfield
Partner - Champion
Partner - Champion

Caption Tab > Special Icons > Send to Excel

Adny

rcorcoran
Creator
Creator
Author

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

Rhona

chrislofthouse
Partner Ambassador
Partner Ambassador

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.

rcorcoran
Creator
Creator
Author

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

Rhona

awhitfield
Partner - Champion
Partner - Champion

Enable 'copy Image to ClipBoard'

rcorcoran
Creator
Creator
Author

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

Thanks again

rcorcoran
Creator
Creator
Author

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

Rhona

awhitfield
Partner - Champion
Partner - Champion

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