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
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.
Thanks but this only exports a bar or line chart as text I want the actual chart to show
Caption Tab > Special Icons > Send to Excel
Thanks but this only exports the data I want a bar or line chart to export as a chart
Enable 'copy Image to ClipBoard'
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.
I don’t have the copy to clipboard option in access point. Where in the QMCdo I need to allow this
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)
This is on an individual chart basis, under caption in the chart properties.
Ok print and export to excel are enabled for all users in the QMC but not working
So, are you opening the dashboard using the IE Plugin OR Full Browser Version, in the Access Point?
Not sure I have to go to meeting will reply to these later thanks for all your help
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
Retrieving data ...