You need to sign in to do that
Don't have an account?
Greg Finzer
How to export bar chart report?
I have a standard report in Salesforce that has a bar chart on it. When I export it to excel it just has the detail and not the bar chart. How do I include the bar chart?
Please refer this link
https://success.salesforce.com/ideaview?id=087300000006n4zAAA
https://success.salesforce.com/ideaView?id=0873A0000003UNuQAM
All Answers
Please refer this link
https://success.salesforce.com/ideaview?id=087300000006n4zAAA
https://success.salesforce.com/ideaView?id=0873A0000003UNuQAM
The workaround is difficult to code by using the fact map of your report (if complicated data) and alasql or excel add-in (javascript) to mimic the current standard export of report in excel.
A button call a small visualforce page with remote accesses in javascript to the fact map (apex controller) and generates on-the-fly an excel file (table and chart).
Visualforce Export Excel Report Using Javascript Remoting and AlaSQL
https://nitinkhunalsalesforce.wordpress.com/2016/10/27/visualforce-export-excel-report-using-remote-action-and-alasql/ (https://nitinkhunalsalesforce.wordpress.com/2016/10/27/visualforce-export-excel-report-using-remote-action-and-alasql/)
https://github.com/agershun/alasql/wiki
https://github.com/agershun/alasql/wiki/Google-Charts
Work with Charts using the Excel JavaScript API 03/19/2019 (no sample with VFP/apex but the best JS API if that works):
https://docs.microsoft.com/en-us/office/dev/add-ins/excel/excel-add-ins-charts
Get the exact data of the report in apex:
https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_analytics_report_data.htm
https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_analytics_fact_map.htm
- Create a dashboard
- Add report to dashboard
- Open the chart in full screen
- Press button download (it will download with full chart in png file)
Hope it helps you